# How to send local db components to google sheets? **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [March 13, 2022, 9:51am UTC](https://community.thunkable.com/t/how-to-send-local-db-components-to-google-sheets/1781435 "2022-03-13T09:51:32Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![dhanushan48608nkfw](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@dhanushan48608nkfw](https://community.thunkable.com/u/dhanushan48608nkfw)\ **Post date:** [March 13, 2022, 9:51am UTC](https://community.thunkable.com/t/how-to-send-local-db-components-to-google-sheets/1781435/1 "2022-03-13T09:51:32Z")
Hello everyone, I’m making an VEGETABLE DELIVERY APP. 1. The user will select the vegetables from an online list and add them to his cart. (The cart is offline -LocalDB) 2. When the user clicks the “Place order Button” the data from the localDB should be uploaded to the google sheets. 3. The owner could receive the order details of every user. i need the help with 2nd step. This is the part i’m struggling on. Can anyone help me with this? Thanks ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [March 13, 2022, 2:34pm UTC](https://community.thunkable.com/t/how-to-send-local-db-components-to-google-sheets/1781435/2 "2022-03-13T14:34:04Z")
Welcome to Thunkable. You need to explain more so you can get an answer. How the user gets the product list in the first place if it is **off line**? If the user is getting the product list from the Google sheet then as long as you can read from it then you can also write to the Google sheet. It you know which row in the Google sheet to be updated then use this block. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/9/e91bf05d6f6f1ea4f5da46c1408eec1abb7e1c2f.png) ---
**Author:** ![dhanushan48608nkfw](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@dhanushan48608nkfw](https://community.thunkable.com/u/dhanushan48608nkfw)\ **Post date:** [March 18, 2022, 11:37am UTC](https://community.thunkable.com/t/how-to-send-local-db-components-to-google-sheets/1781435/3 "2022-03-18T11:37:29Z")
Thanks for your reply, I’m sorry i wasn’t clear. THIS IS A VEGETABLE DELIVERY APP 1. The user will select the vegetables from an online list and add them to his cart. (The cart is offline -LocalDB) 2. When the user clicks the “Place order Button” the data from the localDB should be uploaded to the google sheets. 3. The administrator will check the order details of every user. i need the help with 2nd step. ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [March 18, 2022, 11:47am UTC](https://community.thunkable.com/t/how-to-send-local-db-components-to-google-sheets/1781435/4 "2022-03-18T11:47:56Z")
> [@dhanushan48608nkfw](#): > > When the user clicks the “Place order Button” the data from the localDB should be uploaded to the google sheets You will need to loop through the local DB rows and create/update a respective row in Google sheet. See this example image ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/9/998aa3852176c3668943f71666b2f3dcc27012be.png) ---
**Author:** ![dhanushan48608nkfw](https://avatars.discourse-cdn.com/v4/letter/d/fbc32d/32.png) [@dhanushan48608nkfw](https://community.thunkable.com/u/dhanushan48608nkfw)\ **Post date:** [March 21, 2022, 11:18am UTC](https://community.thunkable.com/t/how-to-send-local-db-components-to-google-sheets/1781435/5 "2022-03-21T11:18:07Z")
Thank you sir, What is the purpose of variable myRow in your example? ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [March 21, 2022, 12:18pm UTC](https://community.thunkable.com/t/how-to-send-local-db-components-to-google-sheets/1781435/6 "2022-03-21T12:18:06Z")
> [@dhanushan48608nkfw](#): > > What is the purpose of variable myRow This is an object containing the values of each column in that row to enable you reading the data of individual columns and save it to the table in Google sheet. See this example of sorting a local DB but will show how to move data from one table to another. This example is using 2 localDB but the same is true when one localDB and the other is Google sheet. [https://x.thunkable.com/projectPage/6103dec760c70500ef73d4b0](https://x.thunkable.com/projectPage/6103dec760c70500ef73d4b0) ---
**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\ **Post date:** [June 19, 2022, 12:18pm UTC](https://community.thunkable.com/t/how-to-send-local-db-components-to-google-sheets/1781435/7 "2022-06-19T12:18:13Z")
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.