Fix Google Sheet Sync

Заказчик: AI | Опубликовано: 16.10.2025
Бюджет: 3000 $

I pull live market data from a Google Sheet into my site, https://todaystockprediction.com/, but the feed often arrives half-empty. The Google Sheet sometimes takes too long to finish its own formulas, so when my MySQL import script runs it grabs an incomplete snapshot. The glitch shows up randomly—some refresh cycles are perfect, others drop entire columns or rows. I need someone who can trace the full path—from the Sheet’s formulas and triggers to the PHP/MySQL fetch routine—and make the update rock-solid. You may decide to optimise the formulas, add timed retries, stage the data in a buffer table, or cache the last good set; I’m open to any clean solution as long as every scheduled pull ends with a 100 % complete dataset reflected on the site. Deliverables • A fault-tolerant sync mechanism that guarantees the page always shows fully populated values. • Clear comments or brief documentation explaining what you changed, where to adjust timings, and how to extend it later. • One week of smooth, error-free operation on the live server to confirm the fix. If you have tackled similar Google Sheet → MySQL integrations, let me know—especially if you have tricks for slow-loading formulas.