Automate Weekly Google-Zoho Sync

Every week I have to pull the same inventory numbers out of Google Sheets, key them back into Zoho, copy everything into Excel, and then do a quick analysis before the Monday meeting. I am still doing all of this manually and it is starting to eat entire afternoons.

What I need is a repeatable, largely hands-free process that:
• grabs the latest inventory data from my Google Sheet,
• updates the corresponding records in Zoho,
• drops a fresh copy into an Excel file, and
• leaves me with a clear summary tab so I can spot variances at a glance.

A lightweight script (Apps Script, Zoho API, Power Query, or anything equivalent) that I can trigger once a week is ideal. The final Excel workbook should already include the basic analysis I do now—simple calculations, a variance column, plus a small chart. Once it is set up, I should only have to press a button, wait a minute, and open the finished report.

I will provide sample spreadsheets, Zoho access, and a quick rundown of the current manual steps. You handle the automation, make sure the fields map correctly, and show me how to run it without any coding knowledge. A short screen-share or written walkthrough at the end will be plenty for hand-over.