# \[SOLVED\]Update to Bubble DB from Google sheets via Blockspring **URL:** \ **Category:** Blockspring\ **Created:** [September 14, 2016, 3:24am UTC](https://forum.bubble.io/t/solved-update-to-bubble-db-from-google-sheets-via-blockspring/5961 "2016-09-14T03:24:35Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![samuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/samuel/32/2239_2.png) [@samuel](https://forum.bubble.io/u/samuel)\ **Post date:** [September 14, 2016, 3:24am UTC](https://forum.bubble.io/t/solved-update-to-bubble-db-from-google-sheets-via-blockspring/5961/1 "2016-09-14T03:24:35Z")
Hi, I need to update the values in my bubble database from the google sheet. ex: I have the below data in the google sheet. ![](https://us1.discourse-cdn.com/bubble/original/2X/8/8706aeb527821198353029f184fd6e7b00534073.png) I connected to this sheet via block spring using the option “Read worksheet”. while creating the repeating group with below logic ![](https://us1.discourse-cdn.com/bubble/original/2X/5/51985a4da08476664cfe3b7cc176cac9a1ace0bc.png) ![](https://us1.discourse-cdn.com/bubble/original/2X/8/8499fc981d58262a88b5d2f3ee54672129766dee.jpg) I am getting the output along with the headers as value ![](https://us1.discourse-cdn.com/bubble/original/2X/4/441ab4bf267bcbf19d6982dfba810c6baf45c112.png) I am afraid am using wrong service “Read worksheet” to meet my requirement. My requirement is: I need to update the **total sold** values from the Google sheets to my bubble DB. Appreciate your Help. ---
**Author:** ![samuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/samuel/32/2239_2.png) [@samuel](https://forum.bubble.io/u/samuel)\ **Post date:** [September 16, 2016, 7:32am UTC](https://forum.bubble.io/t/solved-update-to-bubble-db-from-google-sheets-via-blockspring/5961/2 "2016-09-16T07:32:06Z")
@NigelG Can you please help me with this? ---
**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.bubble.io/u/NigelG)\ **Post date:** [September 16, 2016, 7:36am UTC](https://forum.bubble.io/t/solved-update-to-bubble-db-from-google-sheets-via-blockspring/5961/3 "2016-09-16T07:36:23Z")
I no longer use Blockspring I am afraid, I know people had issues with the Sheets Read in the past. Maybe look at using Zapier ? Or read the thing directly if it Public ? ---
**Author:** ![samuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/samuel/32/2239_2.png) [@samuel](https://forum.bubble.io/u/samuel)\ **Post date:** [September 16, 2016, 7:48am UTC](https://forum.bubble.io/t/solved-update-to-bubble-db-from-google-sheets-via-blockspring/5961/4 "2016-09-16T07:48:57Z")
Hi @NigelG My Requirement is to update a table using different CSVs by different users. Earlier I raised a forum request if we have a feature in uploading the CSV in live mode which could solve my problem. Unfortunately this feature is not in bubble. > [@CSV Upload in the preview mode/Live Mode](http://forum.bubble.io/t/csv-upload-in-the-preview-mode-live-mode/4270): > > Hi, As per my knowledge, we can upload the CSVs in Design mode via [image]. Is there any way to upload the CSVs in the preview mode through pages? so that a user can upload the data in Bulk to the Database instead of one-by-one through input fields. Regards Since this feature is not available in bubble, I thought of creating google sheets to the different users where they upload the data which can then be fetched into a table in bubble via blockspring. Can you please suggest any alternate solution to achieve this? ---
**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.bubble.io/u/NigelG)\ **Post date:** [September 16, 2016, 1:21pm UTC](https://forum.bubble.io/t/solved-update-to-bubble-db-from-google-sheets-via-blockspring/5961/5 "2016-09-16T13:21:53Z")
There are a few options, none all that easy… **Google Sheet \> Zapier Zap \> Bubble** Works quite nicely for smaller numbers, triggers each time a row is changed so not ideal for “bulk” uploads **Read Google Sheet directly** Google offers an API to do this, and it works very nicely. However it returns a list of values, which Bubble can’t handle. You could probably use Blockspring to flatten it. **Get them to email the csv and put it through [mailparser.io](http://mailparser.io) ($25 a month but pretty awesome magic).** **Copy and paste the CSV into a multi line input, and somehow convert the csv to JSON with Blockspring** ---
**Author:** ![samuel](https://sea1.discourse-cdn.com/bubble/user_avatar/forum.bubble.io/samuel/32/2239_2.png) [@samuel](https://forum.bubble.io/u/samuel)\ **Post date:** [September 16, 2016, 1:28pm UTC](https://forum.bubble.io/t/solved-update-to-bubble-db-from-google-sheets-via-blockspring/5961/6 "2016-09-16T13:28:45Z")
Thanks @NigelG Will give them a try… ---
**Author:** ![NigelG](https://avatars.discourse-cdn.com/v4/letter/n/ea5d25/32.png) [@NigelG](https://forum.bubble.io/u/NigelG)\ **Post date:** [September 16, 2016, 1:29pm UTC](https://forum.bubble.io/t/solved-update-to-bubble-db-from-google-sheets-via-blockspring/5961/7 "2016-09-16T13:29:32Z")
It really depends on what this file of data is like … fixed data, size etc etc Ping me a mail if you need a hand. ---
**Author:** ![felipe](https://avatars.discourse-cdn.com/v4/letter/f/90db22/32.png) [@felipe](https://forum.bubble.io/u/felipe)\ **Post date:** [July 10, 2017, 2:40am UTC](https://forum.bubble.io/t/solved-update-to-bubble-db-from-google-sheets-via-blockspring/5961/8 "2017-07-10T02:40:10Z")
hello @samuel would you share how you solved this issue? kind of having the same here… tks !!