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.

Best answer

Google Forms trigger from form in Shared Drive

V

Hi everyone~

 

I have a quick question. So is it possible to connect to a google form or any other Document that is in a “Shared Drive” space?

 

Thank you!

icon

Best answer by Troy Tessalone 21 June 2021, 22:32

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

13 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @VFXRack 

For GDrive: You can't trigger or act upon a folder shared with you, so files added to folders you don't own will not trigger the Zap. The connected account must be the owner.

https://zapier.com/help/doc/common-problems-with-google-drive

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

Hi @Troy Tessalone 

 

Thank you for the quick answer.

 

So if I created a file and moved it over to a shared drive, it should still trigger the zap?

 

Thank you in advance.

Troy Tessalone
Userlevel 7
Badge +14

@VFXRack

The connected account must be the owner of the shared drive where the file is located/moved.

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

So I’ve created a google forms in a Shared Drive that I own. When I try to set up a trigger in a zap, I can’t locate the form.

Troy Tessalone
Userlevel 7
Badge +14

@VFXRack

The GForm saves responses to a GSheet: https://support.google.com/docs/answer/2917686?hl=en

So you’ll need to specify the GSheet as the trigger.

 

I can't see my Google Form spreadsheet in the dropdown

Google Form responses need to be saved to a Google Sheet in order to work with Zapier.

To resolve this, you'll want to adjust where you save your Google Form responses using this guide and ensure they're saved in a Google Sheet.

The Google Sheet will then become selectable in the dropdown when setting up your Zap.

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

I have that created but it still doesnt locate the sheet.

It reads it when the file is in “My drive” and as soon as I move it into my “Shared drive” it disappears.

Troy Tessalone
Userlevel 7
Badge +14

@VFXRack

Is the GSheet nested under a folder?

Try inputting the ID of the GSheet.

Also make sure the share permissions for the file/folder are set correctly.

See this related topic:

 

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

I got it to work! It takes about 15-20 mins for it to zap, is that normal since its from a shared folder?

 

Thank you @Troy Tessalone for all the help! 

Troy Tessalone
Userlevel 7
Badge +14

@VFXRack

The Google Sheets trigger is marked "instant" but it still takes a few minutes to trigger

The triggers for Google Sheets are unique among Zapier triggers. When there is a trigger event in the spreadsheet, Zapier gets a notification webhook from Google about this. After that, Zapier sends Google Sheets a request for new data, so it uses both the polling and instant trigger methods. This process takes about 3 minutes overall.

While not being "instant", these triggers are faster than regular polling ones, as they don't depend on the polling interval of the plan your account uses.

 

Trigger types

There are 2 types of triggers:

  1. Polling trigger: the majority of triggers are polling triggers. With a polling trigger, Zapier will check for new data from your trigger every 1 to 15 minutes in order to start your Zap, depending on your pricing plan.
  2. Instant trigger: with an instant trigger, your trigger app will send Zapier an instant notification whenever there's new data. Zaps with instant triggers are labeled Instant on your dashboard and in the Zap editor.
⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
V

Hi @Troy Tessalone 

 

So after testing a few zaps, my zaps arent triggering. When I test out (via editor) the zap it triggers but when I fill out my forms it doesn’t trigger the zap.

 

Any reason why?

Troy Tessalone
Userlevel 7
Badge +14

@VFXRack 

What Zap trigger are you using?

You may have to wait up to 15 minutes for the Zap to trigger depending on your Zap plan and the trigger being used.

Check your Zap Runs: https://zapier.com/app/history

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

Trigger

  1. New Reponse in Spreadsheet in Google Forms

Action

  1. Create Ticket in Repairshopr

 

Everything has checked marked, when I test the zap it works and creates a ticket in my Repairshopr. When I fill out the form after its turned on it doesn’t zap.

 

There isnt any runs in my history. 

Troy Tessalone
Userlevel 7
Badge +14

@VFXRack 

May be best to open a ticket with Zapier Support so they can troubleshoot further with you: https://zapier.com/app/get-help

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