I found a related topic that mentions creating a button to create a manual push from Airtable to Google Sheets. However, it was more focused on the pull from google sheets vs the push to google sheets.
Forgive my lack of knowledge, but my goal is for ANY Airtable updates in one particular view to update a Google sheet. The purpose it retain our Source of Truth, BUT share data in spreadsheet format to someone on our team and they prefer Google sheets.
We would not want them to update any fields in this Google sheet, but they should be able to view it and have it as up-to-date as possible.