Fixing Data Row Issues in Zapier for Google Sheets to Clay Integration

Hi all - I'm using Zapier to push multiple rows from a google sheets into Clay - all the data is appearing in 1 row in Clay, rather than on separate rows. Unsure if anyone knows how to fix? This may be a Zapier question rather than a Clay question.

8 comments

Bruno R.
·
·
Hi Alex, thanks for reaching out. Can you share url of the table your working in here so I can take a look? Also, can you provide us with some context on the zapier workflow and what transformation steps the google sheets data is going through before being pushed to the webhook table?
Alex L.
·
·
The zapier workflow creates multiple spreadsheet rows in Google Sheets. Then I selected looping by Zapier to create records in a clay table. This is a link to the clay table I've connected to - https://app.clay.com/workspaces/263591/workbooks/wb_7oyzSYhXFzVR/tables/t_gudgsTA8Uwo8/views/gv_PdpUUM2rKUjK rather than creating 6 rows it puts all 6 names into the same cell in 1 row
Bruno R.
·
·
Got it! Could you provide a step-by-step breakdown of your Zapier workflow setup? The issue might lie there. If you can, a video walkthrough would be even better! Alternatively, reaching out to Zapier's support team could be more efficient, as they’ll have full access to your workflow details.
Channeled
APP
·
·
Hey there - just wanted to check in here to see if you needed anything else! Feel free to reply back here if you do.
Alex L.
·
·
https://share.vidyard.com/watch/vSvZaGAdC2EwUTdoVARkux?
LuisArturo
·
·
Hey there Alex thanks for reaching out, taking a look at your setup what is going on here is that in your Zapier setup, every contact is embedded within the first contact you have, which is why they all are in the same row. https://downloads.intercomcdn.com/i/o/w28k1kwz/1262446842/2856ead92c02326f411db88151c0/image.png?expires=1732299300&signature=a5beaf8e08bae220c524a244f5d3150cf228df957493dd66fad242f3e782ef74&req=dSIhFM16m4lbW%2FMW1HO4zUvEo3M8QE6uUOzxWmPvd3Ay6KPjJcZYEPWebLR9%0AUBDu%0A You would need to make sure that each contact is its own value. We have a loom video that shows how we can setup a Zapier from Google Sheets to Clay thjat you may find helpful. You can watch it here.
Alex L.
·
·
thanks for your help! much appreciated! Think you forgot the URL to the video. Not sure how to ensure each contact is it's own value 😅
Daniela D.
·
·
Hey Alex! Sorry about that. Here's a quick video guide: - https://www.loom.com/share/9c89bd45c19c4daa8af0d928a70b8ddc?sid=284e0e92-5cf7-4ae5-b771-e6afbc78c799 https://www.youtube.com/watch?v=QTfmeWTeyPM Let me know if this helps!