Assistance with AI tool/API Integration

I have an existing web app that needs one specific integration fixed. It's not a build-from-scratch job — the app already works, but one data connection is broken. Current setup: Frontend hosted on Netlify, code in a GitHub repo (generated with AI assistance, so the codebase may look a little unconventional — happy to walk through it) Supabase used as the backend database, storing user session/input data so it persists between logins The dashboard is a cash flow tool for residential builders (opening/closing balances, forecasting) The problem: The dashboard currently pulls cash flow forecast data from a Google Sheet (originally an Excel file, converted to Sheets). That connection only grabs a static snapshot — when the source data in the Sheet is updated, those changes don't flow through to the dashboard. It's not clear whether the break is in the Netlify build/fetch step or the Supabase sync — need someone who can diagnose and fix it. What I need: Diagnose where the sync is breaking (Netlify fetch vs. Supabase sync vs. something else) Get the Google Sheet → dashboard connection updating in real time (or on a reasonable refresh interval) when the source sheet changes Brief documentation/explanation of the fix so I can maintain it going forward Available for a quick call to review the existing repo and Supabase setup Nice to have: Comfortable working with AI-generated codebases (Claude-generated in this case) Experience with Netlify deploy hooks / build triggers and Supabase real-time subscriptions or scheduled syncs Ideal freelancer: Strong with Supabase, Netlify, and Google Sheets API Can turn this around quickly — it's a targeted fix, not a rebuild Clear communicator, can explain the fix in plain terms