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 have an integration with a SquareSpace form and want the values of the form written to a sheet (tab) in the google spreadsheet. I have started to set up “Create Spreadsheet Row”, but cannot find the spreadsheet.

The spreadsheet is in a Google Workspace Shared Drive, and it is shared with the user account that is running the Zap. However, that user account is not a member of the Shared Drive -- the file can be accessed in the “Shared With Me” folder, but that user cannot see the Shared Drive or scan it.

So when I am in Zapier looking for the document, and selecting Drive, the Shared Drives I am a member of appear, as well as My Drive, but the drive where the file is does not.

Is there a way to specify the driveID or other values to get at the tab of the sheet?

 

Thanks!

TomH

 

 

Hey ​@tomh,

There are few options you can try to fix this-

  • Enter the Spreadsheet ID manually in Create Spreadhsheet Row action. You can find the ID in the Google Sheets URL
  • Copy the spreadsheet to your Google Sheets account so the Zap will have the access.

Here is a helpful article about adding custom value to dropdown menu fields- https://help.zapier.com/hc/en-us/articles/8496241696141-Add-custom-values-to-dropdown-menu-fields-in-Zaps. Hope it helps!

 

The magic is that the Drive value is optional, so adding the spreadsheet ID did the trick.


Thanks!!

Terms & ConditionsAccessibility statement