# CSV to Google Sheets **URL:** https://community.make.com/t/csv-to-google-sheets/1720 **Category:** Beginner Questions **Created:** [June 2, 2022, 1:18pm UTC](https://community.make.com/t/csv-to-google-sheets/1720 "2022-06-02T13:18:47Z") **Posts on this page:** 8 **Page:** 1
### Author: ![Test\_Test](https://avatars.discourse-cdn.com/v4/letter/t/6de8d8/32.png) [@Test\_Test](https://community.make.com/u/Test_Test) #### Post date: [June 2, 2022, 1:18pm UTC](https://community.make.com/t/csv-to-google-sheets/1720/1 "2022-06-02T13:18:47Z")
Hi all, My first post here so please be gentle 🙂 I’m not a code writer, so please be even more gentle 😛 There’s a government database which is updated on a daily basis. I’d like to find the best, and most reliable/stable, method of grabbing this database everyday and update a Google Sheet. There are two options to access this database: 1. [Download CSV](https://data.gov.il/dataset/rechev-tag-nachim/resource/c8b9f9c8-4612-4068-934f-d4acd2e3c06e/download/c8b9f9c8-4612-4068-934f-d4acd2e3c06e.csv) 2. [HTTP request](https://data.gov.il/api/3/action/datastore_search?resource_id=c8b9f9c8-4612-4068-934f-d4acd2e3c06e&limit=500000) Is there a way that can avoid having to itirate new rows into Google Sheets? I know about this [bulk option via the API](https://community.make.com/t/insert-multiple-rows-into-google-sheets/1543), but that’s still a big of an overkill I think. Thanks ---
### Author: ![loic.wiseflow](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/loic.wiseflow/32/132_2.png) [@loic.wiseflow](https://community.make.com/u/loic.wiseflow) #### Post date: [June 2, 2022, 9:49pm UTC](https://community.make.com/t/csv-to-google-sheets/1720/2 "2022-06-02T21:49:57Z")
Hi @Test_Test , It all depends on how the government database is updated. If they just add new records you can store somewhere the ID (if sequential) or the created timestamp of the last record added to your Google sheet. Then for each new run, you look that value up and only add records that have been added after your last run. This could work with updated records to if the database has a column for last update. ---
### Author: ![make\_expert](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_expert/32/3827_2.png) [@make\_expert](https://community.make.com/u/make_expert) #### Post date: [June 3, 2022, 1:38am UTC](https://community.make.com/t/csv-to-google-sheets/1720/3 "2022-06-03T01:38:28Z")
Hi @Test_Test Ideally for this you will need to use the bulk import API for google sheet. Make has JSON app that can easily create the JSON payload of all the rows you get from CSV, you dont have to use HTTP, rather Google sheet app has API action where you can just use the JSON. [![](https://europe1.discourse-cdn.com/flex013/uploads/make/original/1X/b494dd4b09784955e7aa56413c3a90a9d70f5ac2.png)](https://www.upwork.com/freelancers/~01342b8f8487f506be) ---
### Author: ![Test\_Test](https://avatars.discourse-cdn.com/v4/letter/t/6de8d8/32.png) [@Test\_Test](https://community.make.com/u/Test_Test) #### Post date: [June 3, 2022, 2:06pm UTC](https://community.make.com/t/csv-to-google-sheets/1720/4 "2022-06-03T14:06:28Z")
Hi, So I’m trying to make option 1 work. I trying to use HTTP=\>Get File: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/e/ebf37ac1329bf9ebc8fcf91ad12f0850e90e3c0f.png) I’m doing something wrong, as the output isn’t the actual CSV file: ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/e/ed9514666d9328e58f6faf34b1033ef8e6aac511.png) Yes, I know, I’m doing something very wrong on a very basic level. As said before, be gentle 🙂 My logic is based on the fact that this CSV is downloaded if you simply follow [the link](https://data.gov.il/dataset/rechev-tag-nachim/resource/c8b9f9c8-4612-4068-934f-d4acd2e3c06e/download/c8b9f9c8-4612-4068-934f-d4acd2e3c06e.csv) I pasted in the URL field above. Thanks! ---
### Author: ![Jouher](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@Jouher](https://community.make.com/u/Jouher) #### Post date: [August 18, 2022, 3:42am UTC](https://community.make.com/t/csv-to-google-sheets/1720/5 "2022-08-18T03:42:17Z")
@Test_Test For bulk update, append and clear, we have built a tool where we can save tons of operations. ![image](https://europe1.discourse-cdn.com/flex013/uploads/make/original/2X/9/97c8b7ff85cd378e1d9ae2b04a9df487983ae4c0.png) Feel free to book a slot from Calendly if interested for a demo: > **[Msquare Meeting - Msquare](https://calendly.com/msquarepro/meeting)** ---
### Author: ![TheLjohnson.com](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/theljohnson.com/32/18736_2.png) [@TheLjohnson.com](https://community.make.com/u/TheLjohnson.com) #### Post date: [April 12, 2023, 12:16am UTC](https://community.make.com/t/csv-to-google-sheets/1720/6 "2023-04-12T00:16:40Z")
How are you getting these options? are they already gone? ---
### Author: ![Jouher](https://avatars.discourse-cdn.com/v4/letter/j/f6c823/32.png) [@Jouher](https://community.make.com/u/Jouher) #### Post date: [April 14, 2023, 1:01am UTC](https://community.make.com/t/csv-to-google-sheets/1720/7 "2023-04-14T01:01:58Z")
Which options? Please let me know ---
### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot) #### Post date: [December 7, 2023, 3:07pm UTC](https://community.make.com/t/csv-to-google-sheets/1720/8 "2023-12-07T15:07:22Z")