Hi,
I have input information structured in this way:
And I want this information to be injected in my Google Sheet document such as:
What is the Zapier action I need to perform?
Could someone help me step by step?
Thank you,
Dan
Best answer by Troy Tessalone
View originalI 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.
+9
Hey there,
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!
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):
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?
+14
Hi
Good question.
Can you post detailed screenshots with how your Zap steps are configured so we can have more context?
Yes
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
+14
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?
+14
Map the variables from the Formatter step to the desired GSheet columns, similar to this:
BUT how to insert this splitted text into the different cells in different lines in Google sheet?
+14
Please provide screenshots to provide clarity about how your Zap steps are configured now.
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
From Step 5: I have output
Info1, Info2, Info3
In the last Step 7, I want
Initially I have this from Step 3
+14
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!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
