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. ✌️
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
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.
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...
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!
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.
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)
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 🤝
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?
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.
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
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 🥷
finally I found someone that has more tabs open than I do
😂😂
Yeah he definitely wins 😹
@@godhands6929 my average is more than 50 in each profile :) , and always keep then in sleep with workoona to save the resources, try it
Nobody tell him about OneTab
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. ✌️
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
This video actually saved me considering I was just getting worried about my large scale Google sheets usage - thanks Nick!
Good to see you back, Nick! Keep up with the great work
Great to see you back in the long form.
Thank you Mustafa 🙏
You are maddddd, 950 operations to 3 operations. Such valuable content, thank you so much!!
Glad you found value Mutiso 🤝
great to see you back nick. after reading you blog i thought you wont be posting the content again :) glad you are back.
Great job! This kind of content is insane! Just saved me 900 operations in a single run.
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
Coming right up 🙏
“Babe, wake up. Nick just dropped a video.”
😂😂
Dude, you just blew my mind with this trick🤯. I love your content and learn automations with you! Thanks for sharing your knowledge.
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 :)
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.
The Champ is back 🙏 missed your videos
Great Video brother 😍, also lookin good with the new hairstyle 🙌🏻
Wow! Thank you, Nick! It’s really helpful ❤
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
Been a while mate! Happy to have you back, nice haircut 💪
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...
I love efficiency, and please show us the other hacks!
Thanks Nick for an amazing video as always.
Just curious why don't you use aggregator and bulk add row?
Making That Bank. Thanks for taking the time. All the best
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!
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.
Nick, how can I set the sheet name to insert the data? Thanks
Woohoo! A new long form video! 🎉
It’s really helpful, Thank you so... so much
Glad to have the sauce back
finally you are back!
excellent info i needed just today. awesome!
Welcome back!
Awesome :) Thanks for the tip. Does this works with multiple operations aggregation of a previous module instead of bundles ?
life saving video! thank you nick
Hey - you are alive, Nick! I was already worried!
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)
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 🤝
This is the G.O.A.T. video.
Hey Nick, could this be done for the high ticket email system?
Terrific! Thanks!
Clever! Hey nick i am wondering if you have developer backgorund?
Could you please do a video on the bulk update a row
Super helpful. Thanks
Appreciate you Glenn 👊
@@nicksaraev gotta support local creators my dude! Love your work and love you're in Van
He’s back
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?
Hey thank you for the amazing video! Can you make the same thing but just for airtable?
Hey the type forms in the career sections at left click are not working
Doesn’t this go against LinkedIn usage policies? How do you approach this subject?
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?
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.
Thank you...
Hey man! After long time?
After a long time on youtube mate
What up bro! I've returned to plague your feed again 😈
@@nicksaraev 😅😂😂😂 extrodinary initiative bro
And he finally emerges from the ether
The ether got boring 😂 I prefer TH-cam
Thank You so much
Gold🔥
Love you bro
Asking much do any chance to be part of your team
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
more open tabs please...
MUITO BOM, DEMAIS
He is baaack!!! 🎉 Letsss gooo!
Now let me in your Skool Community alr 🔫😅
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 🥷
This is the way!🫵🏻😎