How can I quickly fetch Google reviews into a Google Sheet faster?
Status: Open · Asked by Mark Spray on · 0 views
How can I quickly fetch Google reviews into a Google Sheet faster?
I'm using a scheduled task to pull all the reviews, but the shortest interval is 1 minute. The problem is, if I don't stop it manually, the task keeps running and consuming resources.
I need the fastest way to handle a client with 100 reviews. I want to loop through the reviews quickly and complete the process efficiently.
I'm looking for advice from experts to make this smoother for a new client. I also want to avoid the risk of the workflow not stopping properly.
Update SOLVED :
I created a simple php form that asked me for how many times i wanted it to run, then it send a webhook to fire the workflow every 3 seconds and working a treat [IMG alt="?"]https://static.xx.fbcdn.net/images/emoji.php/v9/tf0/2/16/1f603.png[/IMG]
Why php, because i'm used to it more and can just do it in one file and upload it to a web server for team to use.
Hello @markspray
Please provide us with the workflow URL so we can better look for the possibility and assist you accordingly.