Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I am experiencing some difficulties with my Google Sheets integration. My zaps trigger as soon as a new row is added to a sheet, however, it is not pulling through all of the columns, and this is happening across several sheets. It’s pulling through columns A:S, but not T, U or V. Why might this be happening all of a sudden? There is no data in the fields to prevent this from happening. 

 

It’s causing some issues, as those three fields are tied into some important processes, which aren’t working without them. It has suddenly started doing this about 2 weeks ago. 

Hi ​@RGBeechcroft 

For us to have more info, post these screenshots:

  • showing the top 3 rows of your GSheet including those columns
  • how your Zap step is configured in EDIT mode with the field mappings visible

 

Hi Troy, 

 

Please find some screenshots attached. It’s odd. Retrospectively it shows the fields that aren’t being pulled through (it’s the rows relating to ‘Reminder Email Address’, ‘Date of reminder’ and ‘reminder message’.) 

It’s worth noting, these fields aren’t always filled, but for the form submissions that do include these fields, they aren’t always picked up by the Zap for some reason. Really unsure why this is?

The functionality for these fields was added at a later date to the rest (it was new functionality added later down the line), however it has been working fine for a while, and I haven’t made any further changes that will have led to this. 

Just to add to the above, here’s a specific example of a contact that had these fields included in the new line, but they weren’t pulled through. 

Hi ​@RGBeechcroft,

I did some digging into this, and it seems like the behavior that you’re encountering with Google Sheets app is a bug. However, the bug has been fixed a few hours ago. Could you please try to reconnect your Google Sheets account? Additionally, kindly try creating a new Zap and check if the new Zap pulls all of the columns.

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

 

Hi Ken, 

Ah OK, good to know it was a glitch and that I’m not going crazy! It seems to be pulling in all the correct fields again now. 

This had been an issue for about 2 weeks prior to the fix, I’m surprised it took this long to identify, as I imagine the Google Sheets plug-in is one of the most popular. 

This has actually been incredibly frustrating for us, and I’ve spent over a day’s work trying to rectify, re-build and/ or implement a workaround for this issue as it has been heavily impacting my team’s ability to record their appointments. I actually totally re-built our processes to try and get this working again (to no avail until the bug fix came through). 

Is there anything you can do to compensate me for the time and stress this has caused? 

Hey there, ​@RGBeechcroft 👋

Glad to hear it’s pulling the correct fields now. Completely understand how frustrating this must have been, especially given the impact on your team’s workflow and the time you had to spend working on a fix. While we don’t offer compensation for time and stress caused by bugs, I totally understand how valuable your time is, and I’ll be sure to pass along your feedback to our team. We’re always working to improve reliability and response times, and hearing about experiences like yours helps us identify where we can do better.

If there’s anything we can do to help optimize your setup now that things are back on track, please let us know—always happy to assist! 🙂

Terms & Conditions