Q: Does using Google Sheet affects the speed of API response?
If so, would you say uploading an Excel sheet is better because it will using your service directly?
Does using Google Sheet count against the Google Sheets API limit?
If using Google Sheet, if I update my Google Sheet does it auto update the 'database' content that was uploaded to API Spreadsheet. Meaning if we use the API, it will contain the latest update from Google Sheet?
Astha_APISpreadsheets
May 14, 2024A: Hi there, thank you for these questions!
Using Google Sheets is slightly slower than an Excel Sheet so I would recommend that depending on what your use case may be.
Currently, using Google Sheet does not count against the Google Sheets API limit.
And yes, if you update your Google Sheet it does auto update it on API Spreadsheets!