Connect external data via Apps Script

I need an Apps Script that pulls the sales CRM JSON feed every 10 minutes and writes it into a sheet called CRM_Ingest, appending new rows and de-duplicating by Deal ID. Schedule the trigger, include exponential backoff for failed fetches, and log the last successful pull timestamp into a cell on the sheet. Verify the script runs under my account and report any permission scopes it needs.

Before I deploy the Apps Script to run nightly, harden it for the contract team. Surface the points where it can fail silently: API timeouts, auth token expiry, schema changes in the JSON payload, and quota limits. Add retry logic, a compact error summary written to an Errors sheet, and a clear place to drop a new API key so non-developers can rotate credentials without editing code.

My nightly ingest triggered but the log shows a 401 Unauthorized on the first fetch. I updated the API key two days ago but I’m not sure if the script uses a cached key, an old stored property, or a different credential store. I can share the script file name, when I rotated the key, and the error text. What likely went wrong and what precise steps will get the job running tonight?

We have five small Apps Scripts across projects and every token rotation or API change becomes a firefight. I own platform ops. Which concise practices—how to store credentials, how to deploy triggers, and how to audit runs—would reduce incidents and handoffs so the scripts require minimal maintenance while staying secure?