Google Sheets MAR Management
Google Sheets Connector Overview
- Google Sheets is a file connector
- A named range is required to sync data in the Google Sheet
- Upon each subsequent incremental sync, the entire named range is scanned and any changes are reflected in the destination
What Contributes Towards MAR?
The following rules apply:
- Only new or changed rows, count toward paid MAR for the month.
- Unchanged rows do not count toward MAR .
- Total MAR for a sheet equals the largest number of rows synced in any single sync.
- Paid MAR equals changed rows + inserted rows only.
Managing MAR for your Google Sheets connections
The first sync will not incur any MAR, but any subsequent sync after a new row is inserted or a row is updated will incur towards paid MAR.
In practice this works as follows:
- Initial sync with 100 rows, Paid MAR: 0
- Subsequent sync with the same 100 rows, Paid MAR: 0
- Subsequent sync with 1 new row, Paid MAR: 1
You can control which portion of the Google Sheet to sync using a named range. Choose the data that is the most valuable to you analytically and exclude any data that frequently changes and doesn't serve your analytical needs.