Make.com, Google Business API & Zoho Desk API

I need a reliable Make.com scenario that runs once a week, pulls the latest review file from Google My Business (74 locations), and handles it end-to-end.

Scope of work
• Fetch the uploaded Excel file, convert it to Google Sheets format, and store it in a designated Drive folder so I can always reference a clean, consistently structured master sheet.
• Parse each row (timestamp, reviewer name, comment, star rating, location) and, for any entry with fewer than 3 stars, open a Zoho Desk ticket through the API, passing those same five fields into the ticket layout.
• Add an email-based error alert so I’m notified immediately if the scenario fails at any step—file pickup, conversion, API calls, or data write-back.

You’ll receive access to:
My Make.com workspace with the Google My Business connection already authorised, plus the Zoho Desk API credentials you’ll need for ticket creation.

Acceptance criteria
1. Scenario runs on a scheduled weekly trigger without manual intervention.
2. Converted sheet is stored in the agreed Drive location in Google Sheets format.
3. Every sub-3-star review generates one unique Zoho Desk ticket with all five fields populated.
4. Any execution error produces an email notification showing the module that failed and basic debug info.
5. Clear hand-off: scenario blueprint and a brief setup note.


If you’ve built similar low-code integrations—or have direct Make.com and Zoho Desk API experience—let me know what approach you’d take and roughly how long you need to deliver a working solution.