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