Update a column in a Google Sheet?

Questions
1

Hello,

I have a Google Sheet that is a leads list for cold emailing. I have a column called “company_name” containing the company names. The problem is that it contains the full legal names or extensions like “… AI” or a short description of the company.
What I need is just the call name or brand name of the company. E.g. “Tesla Inc.” should be just “Tesla”. Or “Example Company | AI Solutions” should be just “Example”.
How to setup a workflow that can either update this column or create a new sheet or a new document with a column that only contains the brand names of the companies?

  • n8n version: latest
  • Database: SQLite
  • n8n EXECUTIONS_PROCESS setting: own, main
  • Running n8n via: Render (self-hosted)
  • Operating system: Windows 11
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.