# \[Solved\] Need to store data in google spreadsheet
**URL:** https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987
**Category:** Questions about Thunkable X
**Tags:** solved, beginner
**Created:** [April 8, 2020, 1:20pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987 "2020-04-08T13:20:54Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@sgirishdds](https://community.thunkable.com/u/sgirishdds)
#### Post date: [April 8, 2020, 1:20pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/1 "2020-04-08T13:20:54Z")
Is there any possible to store the data in google spreadsheet.
Can anyone help me here.
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [April 8, 2020, 2:27pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/2 "2020-04-08T14:27:16Z")
I can think of 3 ways to do this.
zapier
integromat
googlescripts
---
### Author:  [@sgirishdds](https://community.thunkable.com/u/sgirishdds)
#### Post date: [April 8, 2020, 2:35pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/3 "2020-04-08T14:35:36Z")
Can you please help me with googlescripts?
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [April 8, 2020, 2:56pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/4 "2020-04-08T14:56:06Z")
there is a post about this in the forums. it’s not the easiest but not impossible either.
or
Contact me here for programming support / app needs.
[http://jaredgibb.xyz/index.php/contact/](http://jaredgibb.xyz/index.php/contact/)
by @cttricks
[http://community.thunkable.com/t/send-upload-data-to-google-sheets-using-script/68466](http://community.thunkable.com/t/send-upload-data-to-google-sheets-using-script/68466)
or another similar method by me
> [@Sending Emails From Thunkable App | Gmail App](http://community.thunkable.com/t/sending-emails-from-thunkable-x-app-gmail-app/497195/5):
>
> Thank you! I actually fixed it already! Then i got interested and was able to use a script to write to google sheets. It is slightly different than the format you have posted in the past (both of which will be obsolete very soon given the upcoming component release) And my google app script /\* Copyright 2011 Martin Hawksey Licensed under the Apache License, Version 2.0 (the "License"); you may no…
---
### Author:  [@sgirishdds](https://community.thunkable.com/u/sgirishdds)
#### Post date: [April 8, 2020, 6:05pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/5 "2020-04-08T18:05:23Z")
I have tried to do the same, but I don’t know where I am doing mistake. Can anyone help on this?
The below code is script
function doPost(e){
var ss = SpreadsheetApp.openByUrl(“[Novartis sheet - Google Sheets](https://docs.google.com/spreadsheets/d/1Vz9smq0FqfuUCOf_2zqxAwGWXQTj2mbQmyw0Z_sHehI/edit#gid=0)”);
var sheet= ss.getSheetByName(“Sheet1”);
addUser(e,sheet);
}
function addUser(e,sheet) {
var name= e.parameter.name;
name=decodeURI(name);
var id= e.parameter.id;
id=decodeURI(id);
var lab= e.parameter.lab;
lab=decodeURI(lab);
var so= e.parameter.so;
so=decodeURI(so);
var callr= e.parameter.callr;
callr=decodeURI(callr);
var calla= e.parameter.calla;
calla=decodeURI(calla);
var at= e.parameter.at;
at=decodeURI(at);
var act= e.parameter.act;
act=decodeURI(act);
var callc= e.parameter.callc;
callc=decodeURI(callc);
var st= e.parameter.st;
st=decodeURI(st);
var re= e.parameter.re;
re=decodeURI(re);
var pa= e.parameter.pa;
pa=decodeURI(pa);
var mo= e.parameter.mo;
mo=decodeURI(mo);
var rt= e.parameter.rt;
rt=decodeURI(rt);
sheet.appendRow([name,id,lab,so,callr,calla,at,act,callc,st,re,pa,mo,rt]);
}
---
### Author:  [@cttricks](https://community.thunkable.com/u/cttricks)
#### Post date: [April 9, 2020, 4:37am UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/6 "2020-04-09T04:37:59Z")
Hi @sgirishdds you should try this simple method too
> [@Send/Upload data to Google Forms | Using API Component](http://community.thunkable.com/t/send-upload-data-to-google-forms-using-api-component/487956):
>
> Use Google Forms | Spreadsheet, Hi everyone, today one of a thunker asked me about ''How can we upload/send response/data to Google Forms and then to Google Spreadsheet" stuck_out_tongue So i have played with the codes and come up with the solution of this query… and trust me it’s very easy to do that. If you want to know the complete process with step-by-step explanation. [Click here](https://apeunix.com/googleformsinthunkablex) to read the complete blog. Else here is some screenshot and shot description to understand, How you can do tha…
---
### Author:  [@cttricks](https://community.thunkable.com/u/cttricks)
#### Post date: [April 9, 2020, 4:41am UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/7 "2020-04-09T04:41:15Z")
> [@sgirishdds](#):
>
> I have tried to do the same, but I don’t know where I am doing mistake.
You haven’t did the same mate… the POST block is missing in your blocks. Accordig to your current blocks that you have written is only setting-up the URL & QueryParameters of Web\_API component but not calling the POST method to inder data into your spreadsheet
~Ct tricks
---
### Author:  [@sgirishdds](https://community.thunkable.com/u/sgirishdds)
#### Post date: [April 9, 2020, 8:37am UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/8 "2020-04-09T08:37:37Z")
Thank you for your help now it is working fine.
But now I need to get the stored data from google sheet. How to do that?
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [April 9, 2020, 12:35pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/9 "2020-04-09T12:35:13Z")
Getting data is harder, I wonder, why don’t you use airtable? The integration is nearly seamless. Do you feel that you will regularly use more than 1200 rows?
---
### Author:  [@sgirishdds](https://community.thunkable.com/u/sgirishdds)
#### Post date: [April 9, 2020, 2:16pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/10 "2020-04-09T14:16:31Z")
I am developing webpage also but in airtable there is no option to link with webpage. So that only I decided to go with google spreadsheet. Can you help me with this?
---
### Author:  [@jared](https://community.thunkable.com/u/jared)
#### Post date: [April 9, 2020, 3:10pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/11 "2020-04-09T15:10:53Z")
> [@sgirishdds](#):
>
> but in airtable there is no option to link with webpa
You should be able to link airtable to any website using their API. if you are using a website builder, this may pose issues. I would recommend resorting to a website like [stackoverflow.com](http://stackoverflow.com) or [GitHub.com](http://GitHub.com) for HTML help although sometimes you will be able to get it on here!
What are you using to build your site?
---
### Author:  [@sgirishdds](https://community.thunkable.com/u/sgirishdds)
#### Post date: [April 9, 2020, 3:19pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/12 "2020-04-09T15:19:10Z")
I am building webpage on my own, I am not using any online builder. I tried to do with the airtable but it was waste of time, then I tried with google sheet it was very easy to link and work with it. So that only I am changing the application database also to google spreadsheet. In classic version it was very easy to link with spreadsheet, but now it is a bit difficult to work with it.
Can you please help me to work with google spreadsheet?
---
### Author:  [@sgirishdds](https://community.thunkable.com/u/sgirishdds)
#### Post date: [April 10, 2020, 10:26am UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/13 "2020-04-10T10:26:59Z")
Is there any way to do it please help me?
---
### Author:  [@cttricks](https://community.thunkable.com/u/cttricks)
#### Post date: [April 10, 2020, 2:56pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/14 "2020-04-10T14:56:34Z")
Who said you that you can’t link your webpage with airtable. you should take help if **Google Aunty** 😆 or do a little bit of research. If you have a little bit kowledge of Ajax then it’s easy for you to link your airtable sheet. Also linking Spreadsheet also not that tough you can use google app script
---
### Author:  [@sgirishdds](https://community.thunkable.com/u/sgirishdds)
#### Post date: [April 10, 2020, 3:26pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/15 "2020-04-10T15:26:49Z")
I am able to get the data from google sheet to thunkable but I am not able to separate the data in thunkable. Can you help me?
---
### Author:  [@cttricks](https://community.thunkable.com/u/cttricks)
#### Post date: [April 10, 2020, 3:28pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/16 "2020-04-10T15:28:04Z")
Sure, Can you please show the blocks, to see what you have did so far!!!
---
### Author:  [@sgirishdds](https://community.thunkable.com/u/sgirishdds)
#### Post date: [April 10, 2020, 4:36pm UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/17 "2020-04-10T16:36:09Z")
In above blocks I can see all the table values in “Label3”.
But here I am not able to separate the values.
---
### Author:  [@sgirishdds](https://community.thunkable.com/u/sgirishdds)
#### Post date: [April 11, 2020, 6:04am UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/18 "2020-04-11T06:04:51Z")
Can you help me please?
---
### Author:  [@cttricks](https://community.thunkable.com/u/cttricks)
#### Post date: [April 11, 2020, 7:00am UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/19 "2020-04-11T07:00:57Z")
Are you loading your spreadsheet as CSV?
---
### Author:  [@sgirishdds](https://community.thunkable.com/u/sgirishdds)
#### Post date: [April 11, 2020, 7:10am UTC](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987/20 "2020-04-11T07:10:05Z")
Yeah
[Next page](https://community.thunkable.com/t/solved-need-to-store-data-in-google-spreadsheet/562987.md?page=2)