Google reviews auto respond automation for many locations

How To
1

Hey everyone,

I’m running into an issue with an automation I’ve built for a Google My Business account that manages over 50 locations, and I could really use your insights. It’s possible I’m missing something obvious or just not approaching it the right way.

Here’s what the automation does:

  • Every day at 10 PM, it fetches all the locations.
  • It then pulls in all the reviews via an API call.
  • I filter the reviews to keep only those received in the last 24 hours.
  • These filtered reviews are sent to a Google Sheet, then to OpenAI for a reply generation, and finally, the responses are posted back to the respective GMB profiles.

The problem:
When a business receives more than one review within that 24-hour window, only one review seems to be processed and replied to. I’ve gone through the scenario multiple times but can’t pinpoint where the issue lies.

I’ve attached a screenshot of the scenario in case it helps. Happy to provide more details if needed.

Thanks in advance for your help!
Have a great day :slight_smile:

Screenshot 2025-03-25 at 11.36.25
Screenshot 2025-03-25 at 11.36.251776×414 55.5 KB

2

Hey Thai,

can you send some more info? Screenshots of the automation working, input and output bundles, configuration of different modules. This way we can see what is happening here.

From the explanation alone- this tends to happen when you map the first item from an array instead of processing the entire array. But no way to tell if this is your case.