# How can I add a large number of data to a Google Sheet?
**URL:** https://community.make.com/t/how-can-i-add-a-large-number-of-data-to-a-google-sheet/50289
**Category:** Questions
**Tags:** mapping, filters, google-sheets
**Created:** [August 9, 2024, 3:29pm UTC](https://community.make.com/t/how-can-i-add-a-large-number-of-data-to-a-google-sheet/50289 "2024-08-09T15:29:20Z")
**Posts on this page:** 8
**Page:** 1
### Author:  [@AICADAMY](https://community.make.com/u/AICADAMY)
#### Post date: [August 9, 2024, 3:29pm UTC](https://community.make.com/t/how-can-i-add-a-large-number-of-data-to-a-google-sheet/50289/1 "2024-08-09T15:29:20Z")
Hello Community,
My scenario currently looks like this:
1. I upload a CSV with lots of different data to my Drive
2. the file is downloaded
3. ChatGPT should only extract very specific data from this CSV
4. then ChatGPT should bring the data into a table format, with headings that I have previously defined
5. in the last ChatGPT step, it should remove the headings so that the extracted data is in the desired format
Now I want this data to be transferred to a Google Sheet in the format I want.
The headings are already in the Google Sheet. The data should simply be inserted into the list each time.
(Do I have to split the Output into multiple Rows so I can insert them into the Google Sheet?)
Can anyone help me please?
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [August 9, 2024, 3:32pm UTC](https://community.make.com/t/how-can-i-add-a-large-number-of-data-to-a-google-sheet/50289/2 "2024-08-09T15:32:04Z")
See duplicate topics about the use of the “Bulk add rows” module.
- [Help me bulk add array + nested collection into a google sheet?](https://community.make.com/t/help-me-bulk-add-array-nested-collection-into-a-google-sheet/48328)
- [How to bulk map an array of values into multiple rows in same column in Google Sheet](https://community.make.com/t/how-to-bulk-map-an-array-of-values-into-multiple-rows-in-same-column-in-google-sheet/47601)
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
---
### Author:  [@AICADAMY](https://community.make.com/u/AICADAMY)
#### Post date: [August 9, 2024, 3:49pm UTC](https://community.make.com/t/how-can-i-add-a-large-number-of-data-to-a-google-sheet/50289/3 "2024-08-09T15:49:18Z")
Thank you for your reply.
I’m still a bit new to make, so I dont know exactly if I have to add some modules like “JSON” or “Iterators” to my scenario. Could you help me with that?
---
### Author:  [@AICADAMY](https://community.make.com/u/AICADAMY)
#### Post date: [August 9, 2024, 3:50pm UTC](https://community.make.com/t/how-can-i-add-a-large-number-of-data-to-a-google-sheet/50289/4 "2024-08-09T15:50:02Z")
@samliew forgot to mention you in the reply
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [August 9, 2024, 4:18pm UTC](https://community.make.com/t/how-can-i-add-a-large-number-of-data-to-a-google-sheet/50289/5 "2024-08-09T16:18:16Z")
You already have a search module, that should function like an iterator because each result is one bundle.
You need an array aggregator somewhere before the bulk add rows module.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
---
### Author:  [@AICADAMY](https://community.make.com/u/AICADAMY)
#### Post date: [August 9, 2024, 5:06pm UTC](https://community.make.com/t/how-can-i-add-a-large-number-of-data-to-a-google-sheet/50289/6 "2024-08-09T17:06:11Z")
@samliew
It inserted the data, but all in one Cell “A1”.
How can I change that
---
### Author:  [@AICADAMY](https://community.make.com/u/AICADAMY)
#### Post date: [August 9, 2024, 5:30pm UTC](https://community.make.com/t/how-can-i-add-a-large-number-of-data-to-a-google-sheet/50289/7 "2024-08-09T17:30:15Z")
And one more thing. Can I format the output of Chatgpt so that this separator “|” is not transmitted?
---
### Author:  [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [November 7, 2024, 6:42pm UTC](https://community.make.com/t/how-can-i-add-a-large-number-of-data-to-a-google-sheet/50289/8 "2024-11-07T18:42:06Z")