Here is a blogpost I wrote. It shows how, on a schedule, I backup my Airtable data by both exporting to Google sheets, and to my local Mac for offline use.
Check it out and let me know what you think:
https://airtableexport.com/export-data-from-airtable/