whitemole0x
whitemole0x6mo ago

How to add rows to a google sheet

I have an API call node that returns a list of businesses (see the JSON below). I want to add each business to a new row in a google sheet. Can't figure it out 😦
Solution:
Hi @whitemole0x, you can use the Sheets Add Row node. Itterate over the data array using a loop node and pass the item to the data with a incremental value for each cell.
No description
Jump to solution
5 Replies
Solution
Gaurav Chadha
Gaurav Chadha6mo ago
Hi @whitemole0x, you can use the Sheets Add Row node. Itterate over the data array using a loop node and pass the item to the data with a incremental value for each cell.
No description
whitemole0x
whitemole0x6mo ago
@Gaurav Chadha Can you provide an example of what that would look like given the json above? Coming from make.com mapping this is a big learning curve 😬
Gaurav Chadha
Gaurav Chadha6mo ago
Hi @whitemole0x, It would look something similar to this. You can refer to the docs for workfin of each node - https://docs.buildship.com/.
Welcome to BuildShip – BuildShip
A unified resource to start building your backend with low-code. Dive into triggers, nodes, and step-by-step guidance to jumpstart your workflow creation.
No description
Gaurav Chadha
Gaurav Chadha6mo ago
Also, I would love to chat about your usecase and help you migrate workflows from make.com to BuildShip, you can book a call here - https://cal.com/gauravchadha/30min.
Cal.com
30 Min Meeting - Technical Support BuildShip | Gaurav Chadha | Cal...
30 Min Meeting - Technical Support BuildShip
whitemole0x
whitemole0x6mo ago
Great, i booked the call 🙂 thank you