Read and manipulate data in your Google Sheets directly from SAMMI!
For example, you could create your own leaderboard sheet and easily share it with others.
This extension only works with public Google Spreadsheets that have been previously created with it. It cannot read or modify any of your other files.
Some read and write quotas per minute apply (more in documentation).
- Get Data, Find Data
- Append Data, Update Data, Batch Update, Copy Paste, Clear Data
- Auto Fill, Auto Sort, Randomize, Find and replace, Delete Duplicates, Split Text
- Merge Cells, Unmerge Cells, Insert Range, Delete range
- Create Spreadsheet, Duplicate Sheet, Add Sheet
Who is it for?
This extension expects you to have some basic to advanced Google Spreadsheets knowledge. You will also need to have some basic understanding of SAMMI (such as understanding of how objects and arrays work). With this knowledge you can easily add new data, modify them, sort them, retrieve them and much more directly from SAMMI!
Special thanks goes to:
My amazing Patrons.
Thank you so much!
If you would like to support me developing SAMMI itself and my extensions, you can join my Patreon, which will give you access to all my upcoming creations for completely free and priority help on any of my extensions.
DISCLAIMER: The extension is provided as is. The developer has no obligation to provide maintenance and support services or handle any bug reports.
Feel free to edit the extension for your own use. You may not distribute, sell or publish it without the author’s permission.
Important to know
The extension only works with public spreadsheets specifically created with it (see how to make a spreadsheet public). It cannot read or modify any of your other files.
Your read quota is 60 requests/minute and you do not share it with other extension users. There is no daily limit.
Your write quota is 30 requests/minute (you can send batch requests that count as 1 request) and you share it with other extension users.
Total quota is 300 requests/minute. The extension assumes there will be no more 10 users making 30 write requests per minute at the same time, but this might be a subject to change later. There is no daily limit.
How it works
The extension utilizes Google Sheets API endpoints to read and write data.
While reading data is easy, as it only requires an API key, writing data is more complex. The extension ulitizes a custom made API to retrieve your refresh token, as this is only possible server-side and cannot be done from your Bridge.\
The extension ulitizes a custom AWS secure API to retrieve your refresh token, as this is only possible server-side and cannot be done from your Bridge. It never stores or shares any of your credentials and can only ever access public spreadsheets that have been previously created with it.
This developer declares that your data is:
- Not being sold to third parties.
- Not being used or transferred for purposes that are unrelated to the extension's core functionality
- Not being used or transferred to determine creditworthiness or for lending purposes