# How to push data to Google Sheets

**URL:** <https://community.glideapps.com/t/how-to-push-data-to-google-sheets/14052>\
**Category:** Ask for Help\
**Created:** [August 16, 2020, 4:03am UTC](https://community.glideapps.com/t/how-to-push-data-to-google-sheets/14052 "2020-08-16T04:03:37Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Greg\_Maloney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/greg_maloney/32/12027_2.png) [@Greg\_Maloney](https://community.glideapps.com/u/Greg_Maloney)\
**Post date:** [August 16, 2020, 4:03am UTC](https://community.glideapps.com/t/how-to-push-data-to-google-sheets/14052/1 "2020-08-16T04:03:37Z")

</div>

Is there a way of pushing data from the app to your Google Sheet? I thought it would be an action available on the OK button but I can’t find it? 🤔

---

<div class="post-metadata">

**Author:** ![abhilashabhatia](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abhilashabhatia/32/10618_2.png) [@abhilashabhatia](https://community.glideapps.com/u/abhilashabhatia)\
**Post date:** [August 16, 2020, 4:39am UTC](https://community.glideapps.com/t/how-to-push-data-to-google-sheets/14052/2 "2020-08-16T04:39:24Z")

</div>

Do you mean accepting data from app and viewing it in your google sheet? If that is the case, try out Forms [https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/forms](https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/forms)  
Also try out entry field components: [https://docs.glideapps.com/all/reference/components/input](https://docs.glideapps.com/all/reference/components/input)

---

<div class="post-metadata">

**Author:** ![Greg\_Maloney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/greg_maloney/32/12027_2.png) [@Greg\_Maloney](https://community.glideapps.com/u/Greg_Maloney)\
**Post date:** [August 16, 2020, 4:44am UTC](https://community.glideapps.com/t/how-to-push-data-to-google-sheets/14052/3 "2020-08-16T04:44:05Z")

</div>

Thanks for your reply. I’m after something similar to forms but I don’t want the user to have to enter the details. I want the details from the selection to be stored in the Google sheet. e.g. the user selects a menu item and when they click the button all of the details (description, price, etc.) are stored in a Google sheet as a new row.

---

<div class="post-metadata">

**Author:** ![abhilashabhatia](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/abhilashabhatia/32/10618_2.png) [@abhilashabhatia](https://community.glideapps.com/u/abhilashabhatia)\
**Post date:** [August 16, 2020, 4:55am UTC](https://community.glideapps.com/t/how-to-push-data-to-google-sheets/14052/4 "2020-08-16T04:55:52Z")

</div>

Yes, I believe that can be done. Have you looked at Relations yet? [https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/introduction-to-references](https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/introduction-to-references)

You can have the options and associated details in one sheet.

In another sheet, create same columns and a Row ID [https://docs.glideapps.com/all/reference/data-editor/computed-columns/row-ids](https://docs.glideapps.com/all/reference/data-editor/computed-columns/row-ids). Also pass in user email as a special value to note which user has selected that. Build a relation column between this sheet and the previous sheet with static information.

Then, I believe you should be able to display options from the previous sheet and input into the second sheet as user data.

---

<div class="post-metadata">

**Author:** ![Greg\_Maloney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/greg_maloney/32/12027_2.png) [@Greg\_Maloney](https://community.glideapps.com/u/Greg_Maloney)\
**Post date:** [August 16, 2020, 5:01am UTC](https://community.glideapps.com/t/how-to-push-data-to-google-sheets/14052/5 "2020-08-16T05:01:40Z")

</div>

> [@abhilashabhatia](#):
>
> input into the second sheet as user data

Thanks but how do I do this bit: _input into the second sheet as user data_

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [August 16, 2020, 5:51am UTC](https://community.glideapps.com/t/how-to-push-data-to-google-sheets/14052/6 "2020-08-16T05:51:27Z")

</div>

You still need to pass the values into a form via columns components to write them to your Sheet. Glide must know what you want to be written to your sheet and you should specify those fields in your form and what columns to write to.

Else, I have not used this but probably you can try the action with Zapier.

---

<div class="post-metadata">

**Author:** ![Greg\_Maloney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/greg_maloney/32/12027_2.png) [@Greg\_Maloney](https://community.glideapps.com/u/Greg_Maloney)\
**Post date:** [August 16, 2020, 6:07am UTC](https://community.glideapps.com/t/how-to-push-data-to-google-sheets/14052/7 "2020-08-16T06:07:03Z")

</div>

Thanks for your reply. I was trying to avoid that. I thought I’d be able to select the values from the item that had been selected and pass them to the Google sheet. I think I’ve found a way to do it in Thunkable now 👍

---

<div class="post-metadata">

**Author:** ![Gerard\_Fernandez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gerard_fernandez/32/1183_2.png) [@Gerard\_Fernandez](https://community.glideapps.com/u/Gerard_Fernandez)\
**Post date:** [August 16, 2020, 3:42pm UTC](https://community.glideapps.com/t/how-to-push-data-to-google-sheets/14052/8 "2020-08-16T15:42:56Z")

</div>

+1 for exporting from data Editor to G sheets or csv
