About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

Bug: Can't connect to my google account to add row in sheet

  • 24 October 2023
  • 8 replies
  • 46 views
K

This shows the problem: 

I go through the steps outlined here and it appears to work fine but when I return to Zap, I get the ! error. https://help.zapier.com/hc/en-us/articles/8495994922509-How-to-Get-Started-with-Google-Sheets-on-Zapier#connecting-to-google-sheets-0-1

8 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @katandmouse 

Good question.

Try using a new/different private browser.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
K

Don’t know how or why but went back later and it looked to be connected. Set up the google sheet to connect to. It could find it. All looked good. Ran a test. Said the row in the sheet was created. It was not. Tried 4 times. Never worked. 

Then I tried installing the chrome app from the extension store. Now when I select the extension icon and choose create row in Google sheet as the action I want it to take, it links me over to a 404 page. 

Troy Tessalone
Userlevel 7
Badge +14

@katandmouse 

We would need to see screenshots with how your Zap steps are configured.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
K

See if this helps. https://www.loom.com/share/d6d3454ddc664efca137ef12c13a9351

Troy Tessalone
Userlevel 7
Badge +14

@katandmouse 

The Loom didn’t show anything related to Zaps, nor was there any sound.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
K

Hopefully this is better. Sorry about that. 

 

K

And the video of me trying to set it up https://www.loom.com/share/d0fa9362249743d086155fddb1972158?sid=0bfeeb03-955a-4db4-aecb-ff67c2e0bf55

ken.a
Userlevel 7
Badge +6

Hi there @katandmouse,

I’m jumping in to see if I can help!

I looked at the loom.com video, and it seems like the Google Sheets step doesn’t have any data mapped on the fields that’s why it’s sending a blank data to your Google Sheets spreadsheet:

b8697bbb6dbd809f63d119c88c50839b.png
(view larger)

Could you please try mapping the data from the trigger to those fields on your Google Sheets step?

Please let me know if that works.

Reply


Terms & Conditions