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.

Hi,

I’ve a spreadsheet with formula “=importrange(..)”.

Understood that when using =importrange, this kind of query and/or import formula only makes the update at the moment that the sheet is opened. This is a known behavior of the Google Sheets API, as discussed here: https://stackoverflow.com/questions/49268415/how-frequently-does-importrange-refresh — so the delay you're seeing in triggering is corresponding to the times that user opened the sheet.

Seems the Zap trigger is not consistent.  Some trigger 30 mins later, some doesn’t trigger until user open the spreadsheet.  To wait for user open the spreadsheet is a bit doesn’t make sense.  Cos the form is public submission and we don’t know when they submit the form.

My flow:

  • Public submit via Google Forms
  • Spreadsheet A:  Acknowledgement email to respondent via Zap (Trigger any column)
  • Spreadsheet B:  Use =importrange from Spreadsheet A to this spreadsheet B and another email send to respondent via Zap (Trigger ColA=Timestamp)

Anyone have any workaround or solution for the above,

 

@SWMH 

Can you share screenshots of how your Zapier workflow is configured?

What is the goal of importrange? ImportRange requires user granted permissions when referencing a new spreadsheet for the first time. 

Share with you the Zapier Workflow Configuration

 

The goal of importrange is to populate data from Google Forms Response into another Google Sheets namely Coordinator, there is vlookup for the charges and doctor’s email address from the worksheet.  The Zapier workflow only triggers when I open the Coordinator spreadsheet.

Share with you the Coordinator Spreadsheet.

I’ve tried with Trigger with Google Sheets and it works fine with the same spreadsheet (with importrange).

Kindly advise.

@SWMH 
Just checking in to see if you still need help with this? 

Hi @AndrewJDavison_Luhhu ,

 

Thanks for checking.

 

Seems everything working fine now.  Not mistaken, that time it is due to the Zapier issue which has been fixed.

 

 
 

Terms & Conditions