Appending on every run turns a tidy base into six copies of every row. Here is how upsert works in Airtable, and how to choose a merge key that holds up.

Point a job at a CSV link and it re-reads it on your schedule — no download, no manual import. Here is the setup, and the field-type trap to avoid first.

IMPORTJSON is not a Google Sheets function. It is a community script people paste from unmaintained gists. Here is why it breaks, and the routes that do not.