- Secure server-to-server via API keys
In GCP project:
- Service Accounts -> Create New
- Add credentials JSON (with spaces removed) to secure env var
GCP_CREDENTIALS_JSON
- Add credentials JSON (with spaces removed) to secure env var
- Create & share spreadsheet with service account email address (or add Drive permissions)
- Add sheet ID to env var
GCP_SHEET_ID
- Add sheet ID to env var
- Create a sheet tab called "PushSheet" or set the env var
GCP_SHEET_NAME
to the sheet tab name.