Synchronizing the connection between Tinydb and Google Sheets

[TIMAI2]

FAQ Section: Google Sheets

Starter Guides Download a Google Sheet as CSV for the Media Folder and load it at startup - ABG AI2 Google Sheets Component AI2 Spreadsheet component help page - MIT Creating a Credential for Google Sheets - @Gordon_Lu Google link to service account creation May 2023 Peek inside a Service Account .json file - ABG Error reading credentials from stream, 'type' field no specified How To HowTO: Log DateTime Values - PU discussions HOWTO: Get A Range from a Google Sheet - TimAI2 (Also see Web…

https://ai2.metricrat.co.uk/guides

Spreadsheet component. Example. Google Sheets

In order to utilize this component, one must first have a Google Developer Account. Then, one must create a new project under that Google Developer Account, enable the Google Sheets API on that project, and finally create a Service Account for the Sheets API. How to create the Service Account, here: http://ai2.appinventor.mit.edu/reference/other/googlesheets-api-setup.html At the end of the whole process we will obtain a file of the form: app-inventor-338017-8c72fd465555.json We must upload…

FAQ Section: TinyDB

Introductory TinyDB AI2 Help page - MIT Simplest possible TinyDB sample (Phone numbers) - ABG Bugs Intermediate Book Collection in TinyDB(Hossein) Contact Dictionaries in TinyDB - ABG How to save Max Scores on TinyDB - ABG Student names and Emails - TIMAI2 The Tiniest TinyDb Tutorial (Richard) - needs refurbish Advanced TinyDB Namespace Recovery - KIO4 etc. TinyDB after uninstall of an APP Save Base64 of Image Files in TinyDB using extension - Juan Antonio Simulate Multiple Tin…