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
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.
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
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.
Last edited:
