Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

03 Tutorials & Inspiration

03 Tutorials & Inspiration

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.

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

1

7 comments

· Sorted by Oldest

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.
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!