How I Save 10,000 Make.com Operations/Day (Google Sheets Hack)

[@cyrus_zed]

finally I found someone that has more tabs open than I do

[@nicksaraev]

😂😂

[@godhands6929]

Yeah he definitely wins 😹

[@librakhan25]

@@godhands6929 my average is more than 50 in each profile :) , and always keep then in sleep with workoona to save the resources, try it

[@HarveyR1des]

Nobody tell him about OneTab

[@mattgreschuk]

I’m sure you know this Nick but perhaps for others’ benefit… you can replace your text aggregator with the array aggregator module and use the “bulk add rows” sheets module and feed the aggregated array into it. The bulk add rows module will, by default, input the data into the sheet in some weird order (alphabetical?) which is annoying, but you can avoid this by setting the “target structure” in the array aggregator to your sheets module (this only appears once they’re all linked). Then you can specify which array items go to which columns. This saved me so many ops once I figured it out. ✌️

[@EwHaYeB.14]

thanks bro. it did work for me. but i just had to add an 'iterator' before the 'array agregrator' since it was only outputing 1 row only. thanks again

[@Fetestprep]

This video actually saved me considering I was just getting worried about my large scale Google sheets usage - thanks Nick!

[@Brunolincoln89]

Good to see you back, Nick! Keep up with the great work

[@RocknRollCEO]

Great to see you back in the long form.

[@nicksaraev]

Thank you Mustafa 🙏

[@FirstlinkAI]

great to see you back nick. after reading you blog i thought you wont be posting the content again :) glad you are back.

[@mutiso-muathime]

You are maddddd, 950 operations to 3 operations. Such valuable content, thank you so much!!

[@nicksaraev]

Glad you found value Mutiso 🤝

[@drbeckert]

Great job! This kind of content is insane! Just saved me 900 operations in a single run.

[@bradleylambert3284]

Would love to see more Google Sheets API videos! I've been trying to add rows but starting at a certain row number without success with the API so had to do a workaround which worked in the end but used alot more operations than I'd like.

[@yappanesee]

This is life changing, thank you for putting this out there! I started my own agency after i stumbled upon your channel, keep up the great work :)

[@andoni235]

Dude, you just blew my mind with this trick🤯. I love your content and learn automations with you! Thanks for sharing your knowledge.

[@mortlsetortl9237]

The Champ is back 🙏 missed your videos

[@riccardobellicontarini]

Nick, you should do another video on lead generation. I’m struggling to find stuff like emails and reviews. Basically the problem is that anymail finder it’s just so expensive

[@nicksaraev]

Coming right up 🙏

[@chillydoog]

Would you please do a video on chilidogs?

[@Andrew-Moran]

“Babe, wake up. Nick just dropped a video.”

[@nicksaraev]

😂😂

[@mainrongibson3347]

That was great. I would love to see a bulk row update based off of a condition and then continue to the next module, if that makes sense

[@LuukVisscher-r6f]

Very interesting, I would like to know if it is possible to schedule update a list of candidates form a CRM into a database with this functionality. Maybe you could do a video on what the best way is to mirror data from any system in any database with the least operations possible? Wonder how you would approach this!

[@nicksaraev]

Yes, defo possible. You could batch the updates however you'd like, perhaps every hour or two (or sooner if that's important to your application). Solid idea and I'll add this to the queue, thanks Luuk.

[@GreyBeardedBloke]

I love efficiency, and please show us the other hacks!

[@mouradhimmi4236]

Awesome :) Thanks for the tip. Does this works with multiple operations aggregation of a previous module instead of bundles ?

[@hectorprx]

Making That Bank. Thanks for taking the time. All the best

[@GuluMammadli]

Been a while mate! Happy to have you back, nice haircut 💪

[@HarveyR1des]

Woohoo! A new long form video! 🎉

[@OlgaNikitina-o3k]

Wow! Thank you, Nick! It’s really helpful ❤

[@SubrayBanaulikar]

Great Video brother 😍, also lookin good with the new hairstyle 🙌🏻

[@NeuralCatch]

excellent info i needed just today. awesome!

[@tod5444]

finally you are back!

[@_JamesBrown_]

Glad to have the sauce back

[@MichaelRimbach]

Welcome back!

[@emmasincrediblejourney]

life saving video! thank you nick

[@ThanthitaLerttaraseth]

It’s really helpful, Thank you so... so much

[@dustin4274]

question: this won't work if there are filters in place right? for example if not every row needs updating because it was already done (I'm updating a spreadsheet of leads and verifying emails and some are already verified so the filter would be filtering those out)

[@nicksaraev]

Yes exactly Dustin. If you filtered the step before the text aggregator, say on the basis of a status column equalling "verified", those wouldn't be added to the API call that creates the bulk update. Hope this helps 🤝

[@ReneFreitag]

One Question, what I have to to when I have more then one worksheet in my spreadsheet? The Spreadsheet ID is for the complete Spreadsheet? So the Bulk Add to Sheet Modul don't know where to put the data...

[@simfor]

Hey - you are alive, Nick! I was already worried!

[@jakobdango170]

Clever! Hey nick i am wondering if you have developer backgorund?

[@beinnyule5077]

Hey Nick, could this be done for the high ticket email system?

[@EduAndreu-q2x]

Nick, how can I set the sheet name to insert the data? Thanks

[@OlgaNikitina-o3k]

Do you know how to make a photo of invoice and send it to my TG channel and then find all the relevant data in my expenses Google sheet?

[@mainrongibson3347]

Could you please do a video on the bulk update a row

[@arrizona9070]

Hey the type forms in the career sections at left click are not working

[@ANGELG505]

Doesn’t this go against LinkedIn usage policies? How do you approach this subject?

[@nikolapopovic2850]

Hey thank you for the amazing video! Can you make the same thing but just for airtable?

[@RocknRollCEO]

Mate, this is gold as usual... There's also a GSheets Add Bulk rows module.. but never managed to get it to work. Is that module not meant to do the same thing?

[@dougrasd-]

After the first module you have to use an agregator, and then use the array into the bulk add rows module. It’s the same result. But this method via api you can manipulate the strings before adding the values on google sheets.

[@RocknRollCEO]

Thank you...

[@glennbaliong]

Super helpful. Thanks

[@nicksaraev]

Appreciate you Glenn 👊

[@glennbaliong]

@@nicksaraev gotta support local creators my dude! Love your work and love you're in Van

[@benhayden8046]

He’s back

[@ai.sam_hottman]

This is the G.O.A.T. video.

[@devworx.studio]

Terrific! Thanks!

[@rtkkjson]

Hey man! After long time?

[@EasyAiflow_Automation]

Love you bro Asking much do any chance to be part of your team

[@Hygreev551]

After a long time on youtube mate

[@nicksaraev]

What up bro! I've returned to plague your feed again 😈

[@Hygreev551]

@@nicksaraev 😅😂😂😂 extrodinary initiative bro

[@admariner]

Well, this man just saved everyone loads of money in perpetuity + enabled us to make more money for the same cost. Because... that's what Nick Saraev does

[@Ericlundberg-k2n]

Gold🔥

[@moamdanf6806]

Thank You so much

[@DarlingFriend-y3k]

And he finally emerges from the ether

[@nicksaraev]

The ether got boring 😂 I prefer KZbin

[@invisble99]

more open tabs please...

[@EdiJimenezdeHerrera]

MUITO BOM, DEMAIS

[@selcukaslantas]

where are you booooy

[@syntays]

He is baaack!!! 🎉 Letsss gooo! Now let me in your Skool Community alr 🔫😅

[@giuseppevalenza3964]

Oh man, the way that you teach... is something else. And the value of this... don't even let me started on that. Anyway, you prob got bored to see all these compliments (totally deserved tho) below your videos by now, but I'm leaving mine just to give you that YT algorithm love ; ) You know who I am -- I'm the Yacht Guy! Hahah 🥷

[@thomasthelen7874]

This is the way!🫵🏻😎