Send/Upload Data to Google Sheets [ Using Script ]

spreadsheets
database
solved

#1

Hello Everyone,

Many of you are wondring to know how to upload user data to the spreadsheet. There are many possible ways to do that. i.e
◎ Using an Airtable | Cloudstitch etc.
◎ Using Google forms

Few months ago i have written two posts on this same topic. [ View Post 1 | View Post 2 ] But today i’m going to tell you an another way for uploading the users data to the Google Spreadsheet. i.e by using an app script. Kindly follow the below steps to create your 1st app script.

◎ Step 1 : Create a Spreadsheet
Visit this link : https://docs.google.com/spreadsheets to create your google spreadsheet and edit the sheet as shown in the screen shot.

◎ Step 2 : Create App Script
Visit this link : https://script.google.com/home and click on New Script to create your App Script and edit it as shown in the screen shot.

Now you need to create the functions to post data to the spreadsheet! Click Here to Download Code.txt (483 Bytes) After writing the script, Click on PUBLISH and select DEPLOY AS WEB APP.

A popup window will appear where you have to make changes according to the Screenshot. Then click on DEPLOY to get the apps script.

After Successful deployment you’ll get a URL like this one
https://script.google.com/macros/s/AKxxxxxxxx2RzS_HMxxxcH-VYR8xxxxxtFsIfL1xx-Nxxxb/exec

◎ Step 3 : Write your Block
Here is how you’ll write the blocks in the block section of your thunkable project.

Let me know if you all need a tutorial video on this topic!! :blush:
◎ Ct_tricks


Spreadsheets connected to FREE databases (airtable is not free)