Google Sheets: how can find and replace text in cell?

Questions
1

Describe the problem/error/question

Hi everyone! I’m relatively new to n8n and i’m trying to fill a google sheets document with some items that i extracted from a call transcription.

As you can see in the workflow, my last node is a split out node that creates a bunch of items ready to fill a report. In the google sheets document there are some placeholders like {{variable_name}} which corresponds to the variable name of each item.

Unfortunately, I’m struggling to find a solution as the action “update row” doesn’t seem to be helpful. Do you have any solutions?

What is the error message (if any)?

I’m not receiving any error so far.

Please share your workflow

Share the output returned by the last node

I can’t disclose the output of the split out node because it contains sensible information but the output should look something like this:
Item1: variable1
Item2: variable2
and so on…

Information on your n8n setup

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

How do you use the Google Sheet update row node? It is not on the workflow.

You can edit pinned data.

In scenarios where no apparent errors manifest, understanding data structure and ways you’re handling it is crucial to devise a feasible solution.

3

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