How to iterate over Google Sheet records and add them to Quickbase using loops

Question

I am attempting to iterate over several records in a Google sheet in order to add those records to a Quickbase table. I am able to successfully Find the Google sheet and am using the “Get many spreadsheet rows” to create an array of the data in the rows.

What I am struggling with is looping these values. I have the Loop configured to iterate on “line items” being passed from the previous step. When I set the Loop Value to “Rows” and include the array value for “Rows,” it takes ALL row values and puts them into a single record in Quickbase. I cannot figure out how to tell the Loop to iterate over the records WITHIN the Rows array.

rbuschmeyer · Accepted Answer

I found my own answer to this. I did not quite understand that the “Test Step” action only tests the first loop iteration, and that each of my columns needed to be mapped individually. All good now, though.

SamB · Answer

Welcome to the community, ​@rbuschmeyer—great to have you here!🎉Loops can definitely be a bit tricky at first, so wereally appreciate you sharing what you learnt. 🤗 I’ll mark your post as the best answer since it’ll be really helpful for anyone with a similar issue.Feel free to reach out anytime if you need help in the future.In the meantime, happy Zapping! ⚡

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded