Read and manipulate data in your Google Sheets directly from LioranBoard!
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 LioranBoard (such as understanding of how stacks work). With this knowledge you can easily add new data, modify them, sort them, retrieve them and much more directly from LioranBoard!
Special thanks goes to:
SteveLevesque and Djargic for their continued support on Github.
The Argamenmock, EndoSkull, Evan, Panic, DoctorFu, kurocha, Stephen, Ethan, griddark, Kenny, Mill, William, Paul, deaffrasier, Venge, PapaBear Does Stuff, TTarantox, Rodrigo, Harvey Toadface, Alchemy_03, REVAMPEDDRDTH37 Williams, RhinoMonsterGC, JimmyPotato, Bryan, my amazing Patrons!
If you would like to support me in creating more extensions for LioranBoard, you can navigate to the Donate section.
Need a custom tailored extension? Head to the Commissions section!
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 (video guide on 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. 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 Transmitter.
Important: This extension can only modify public spreadsheets that have been previously created with it. It cannot modify or delete any of your other Drive files.
Note for other devs
If you would like to use your own project credentials instead, you will need a bit of Google Cloud and JS coding knowledge, but it is possible to edit the extension for this purpose. I have added comments inside the .lbe file on what modifications to make and some very basic explanation on how to retrieve your refresh token.
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 Transmitter. 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