# Optimize Scenario from parse to Google Sheets
**URL:** https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310
**Category:** Questions
**Tags:** connections, arrays, google-sheets
**Created:** [January 24, 2025, 12:45am UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310 "2025-01-24T00:45:53Z")
**Posts on this page:** 14
**Page:** 1
### Author:  [@Taylor\_P](https://community.make.com/u/Taylor_P)
#### Post date: [January 24, 2025, 12:45am UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/1 "2025-01-24T00:45:53Z")
Hello!
I have a portion of my automation running. I am looking to optimize it to consume less credits. It is for lead enrichment for lead generation.
Currently it does the following:
-searches a row to find the data
-uses perplexity to classify the industry and if it fits the industry I am looking for
- json parse tool to parse the two answers from perplexity
- updates the row one by one with information
Would it be possible to do a bulk upload to sheets? Can it parse them all at once? Open to suggestions to cut down on the actions since I will be processing thousands of leads.
-
---
### Author:  [@kudracha](https://community.make.com/u/kudracha)
#### Post date: [January 24, 2025, 9:11am UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/2 "2025-01-24T09:11:21Z")
@Taylor_P, You can use a text aggregator just after perplexity to accumulate a big text to after generate an array of json objects. then parse whole text as one big json object with answers being in an array. With google sheet module (bulk advanced), you can directly input an array object and it pastes a 2D array your designated range.
Sooo for text aggregator this should work :
if( sheetBundlePosition = 1; { answers : [;emptystring)[perplexityOutput]if(sheetbundleposition!=sheetbundleamount;,;]}
And just parse the text aggregator. might need to work on perplexity output and some json syntax. Ask chatgpt to correct the syntax, shouldn’t be too hard. in the end, you’ll need to parse json from this text aggregate and get an ARRAY object. just one with all the rows and columns.
Let me know if you have some blockers
---
### Author:  [@Taylor\_P](https://community.make.com/u/Taylor_P)
#### Post date: [January 24, 2025, 1:45pm UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/3 "2025-01-24T13:45:46Z")
Ok I do not have any experience doing that unfortunately 😅
This is the current outputs I have from Perplexity and how its being parsed. Is it possible for me to share the scenario and make a quick loom of what you mean?
---
### Author:  [@kudracha](https://community.make.com/u/kudracha)
#### Post date: [January 24, 2025, 1:55pm UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/4 "2025-01-24T13:55:15Z")
@Taylor_P, Yeah, post your exported blueprint. It’s just 1 module to be added. This way you’ll consume 1 + 18 + 1 + 1 operations instead of 1 + 18 + 18 + 18. Perplexity wouldn’t be a problem either if it accepted long inputs. I believe it’s limited to like 50 words or something ? And output also. It can probably be optimized later too (go with batches of 10 rows per perplexity prompt at a time for example).
---
### Author:  [@Taylor\_P](https://community.make.com/u/Taylor_P)
#### Post date: [January 27, 2025, 3:05pm UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/5 "2025-01-27T15:05:30Z")
@kudracha Here it is. Perplexity can take long prompts which you can see from what I have been using, so maybe it can be done multiple at at time?
[Apollo Scrape Blueprint (1).json](https://community.make.com/uploads/short-url/FilmFp4gN94bILw6fccLSADUqy.json) (81.0 KB)
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [January 28, 2025, 4:35pm UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/6 "2025-01-28T16:35:00Z")
Welcome to the Make community!
Try using the Google Sheets “Bulk Update Rows (Advanced)” module:
> Updates multiple rows.
For more information, see [https://www.make.com/en/integrations/google-sheets](https://www.make.com/en/integrations/google-sheets), and [https://www.make.com/en/help/app/google-sheets](https://www.make.com/en/help/app/google-sheets) in the help centre.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make.
---
### Author:  [@Taylor\_P](https://community.make.com/u/Taylor_P)
#### Post date: [January 28, 2025, 5:42pm UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/7 "2025-01-28T17:42:05Z")
To be honest, not much help at all since I dont’ have a technical background. It does not have an example of what it needs to look like
---
### Author:  [@kudracha](https://community.make.com/u/kudracha)
#### Post date: [January 29, 2025, 10:00am UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/8 "2025-01-29T10:00:49Z")
@Taylor_P, I modified your scenario, mainly added text aggregator with correct parameters, referenced the output in parse json. Might need to tweak prompt response and reference correct cells in add row (should be ok i think).
[optimize parse aggreg 1.json](https://community.make.com/uploads/short-url/rsSm3zJbjRw0OBo2bJWETbUYMUX.json) (83.4 KB)
[Apollo Scrape Blueprint (1).json](https://community.make.com/uploads/short-url/FilmFp4gN94bILw6fccLSADUqy.json) (81.0 KB)
---
### Author:  [@Taylor\_P](https://community.make.com/u/Taylor_P)
#### Post date: [January 29, 2025, 6:08pm UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/9 "2025-01-29T18:08:03Z")
@kudracha i used your template and it gave these errors. Looks like some text is added that makes it not valid JSON
---
### Author:  [@kudracha](https://community.make.com/u/kudracha)
#### Post date: [January 30, 2025, 8:32am UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/10 "2025-01-30T08:32:20Z")
@Taylor_P, sorry the emptystring has to be native make function. The pink thing.
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [January 30, 2025, 2:52pm UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/11 "2025-01-30T14:52:17Z")
You can also type the special variables within `{{ }}` brackets, like this:
```plaintext
{{emptystring}}
{{newline}}
```
etc…
Or you could [create keyboard shortcuts](https://community.make.com/t/autocomplete-commonly-used-functions-in-iml-mapping-fields/64748/1) to quickly insert them.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make.
---
### Author:  [@Taylor\_P](https://community.make.com/u/Taylor_P)
#### Post date: [February 1, 2025, 4:59pm UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/12 "2025-02-01T16:59:49Z")
@kudracha I got that fixed, but then i modified it to pull previous values from the google sheet so I could reference them. Everything works, except it doesn’t like using the row variable i pulled in the final google sheet update a row. I am so close! Just need it to accept the row variable, but its not playing nice.
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [February 24, 2025, 2:51am UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/13 "2025-02-24T02:51:49Z")
> [@Taylor\_P](#):
>
> Just need it to accept the row variable, but its not playing nice.
Your JSON is incorrect, try removing these curly brackets in the middle, otherwise you are creating a new “answer” item:
If you need further assistance, please provide the following:
- **Screenshot of module [58]**
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make.
---
### Author:  [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [May 25, 2025, 1:57am UTC](https://community.make.com/t/optimize-scenario-from-parse-to-google-sheets/67310/14 "2025-05-25T01:57:34Z")