Insert text into multiple rows on Google Sheet

I would like to make some precisions:

The input information is in a text format in a single cell in Google Sheet.

The output should be in a different Google Sheet, in the same column, and according the example, in 3 differents rows.

Hey there, @Dan for SEO - thanks for reaching out in community!

Are you able to clarify a bit more on your desired workflow? Where is the data you’d like to populate in Google Sheets being generated from? Sometimes it helps to frame it in the context of:

"When this happens in [blank] app, do that in Google Sheets."

That said, Google Sheets can be a bit finicky sometimes so our squad has put together some excellent resources for how to setup your sheets to optimally work with Zapier. I might recommend giving them a glance over to ensure your setup for success!

• https://zapier.com/help/doc/how-get-started-google-sheets-zapier
• https://zapier.com/help/doc/how-to-set-up-your-google-spreadsheet-to-work-with-zapier

Looking forward to hearing more! 🙂

Hi Christina,

Thank you for getting back to me.

The data is coming from OpenAI.

OpenAI gives me text that I insert in a pre-defined cell in Google Sheet.

I’ve fine-tuned the OpenAI API so that it gives me text in the following form in a unique cell (let’s say A2):

1. Info1;
2. Info2;
3. Info3.

I want that each info (1. Info1, 2. Info2, 3. Info3) is inserted in a different cell, on 3 different rows.

Let’s say “1. Info1” in A3, 1. Info2” in A4 and 1. Info3” in A4.

Is it more clear?

Hi @Dan for SEO 

Good question.

Can you post detailed screenshots with how your Zap steps are configured so we can have more context?

Yes @Troy Tessalone 

So this is how I am asking OpenAI

This is what I get

This is how I insert in a single cell in a Google Sheet document

And I get this but in one single cell

@Dan for SEO 

The results you are experiencing is because the list is returned as 1 data point: choices_1_text

You can try using a Formatter > Text > Split to get these as separate variables to then map as you desire.

OK thank you, now that I’ve split the text.

How do I insert in the Google sheet?

Could you show le please the sequence?

@Dan for SEO 

Map the variables from the Formatter step to the desired GSheet columns, similar to this:

@Troy Tessalone: this is what I’ve done and the text is now splitted thanks.

BUT how to insert this splitted text into the different cells in different lines in Google sheet?

@Troy Tessalone: thiss is what I have now

From Step 5: I have output

Info1, Info2, Info3

In the last Step 7, I want

Initially I have this from Step 3

@Dan for SEO 

If you want data added to the same column but different rows, then the mapped variables need to be comma separated.

 

Help article about using Line Items in Zaps: https://help.zapier.com/hc/en-us/articles/8496277737997-Use-line-items-in-Zaps

Thank you!

I made it!