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. ✌️
Loved it brother. I recently burnt my operations scrapping websites on sheets but not any more. As a new Maker, I'm learning new things everyday to optimize my scenarios. I believe I'm gonna scrape your videos to learn more about make. 😅 Thanks again.
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
Hi Nick, thanks again for all the valuable insights you share. This all works so nicely with appending new rows. Any chance to add two columns into an pre-populated Sheets file? Here's what I'd like to solve: I'm getting the starting addresses and a target addresses from a Sheets row. These are feed into Google Maps and returns Distance and Driving time. Right now, I'm still "cycling" through the rows with approx. 200 operations per run. In best case, these two columns shall be "bulk-added" to the existing Google Sheet. Currently, I write the values into a new Google Sheet and reference the cells in the initial sheet, in order not to burn all the operations. But, of course, this is much less fancy and still "semi-automated" ;-) Kind regards from Germany Idris
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
This was phenomenal. Saved me tens of thousands of operations a day... Thank you - very well done and explained!
Glad it helped man 🙏
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
Loved it brother. I recently burnt my operations scrapping websites on sheets but not any more. As a new Maker, I'm learning new things everyday to optimize my scenarios. I believe I'm gonna scrape your videos to learn more about make. 😅 Thanks again.
Good to see you back, Nick! Keep up with the great work
Great to see you back in the long form.
Thank you Mustafa 🙏
This video actually saved me considering I was just getting worried about my large scale Google sheets usage - thanks Nick!
You are maddddd, 950 operations to 3 operations. Such valuable content, thank you so much!!
Glad you found value Mutiso 🤝
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.
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.
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 :)
Dude, you just blew my mind with this trick🤯. I love your content and learn automations with you! Thanks for sharing your knowledge.
The Champ is back 🙏 missed your videos
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 🙏
Nick, how can I set the sheet name to insert the data? Thanks
Just saved me thousands of operations a month!
Hell ya Kurt, glad it could help.
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
Thanks Nick for an amazing video as always.
Just curious why don't you use aggregator and bulk add row?
Hi Nick,
thanks again for all the valuable insights you share.
This all works so nicely with appending new rows.
Any chance to add two columns into an pre-populated Sheets file?
Here's what I'd like to solve: I'm getting the starting addresses and a target addresses from a Sheets row. These are feed into Google Maps and returns Distance and Driving time. Right now, I'm still "cycling" through the rows with approx. 200 operations per run.
In best case, these two columns shall be "bulk-added" to the existing Google Sheet.
Currently, I write the values into a new Google Sheet and reference the cells in the initial sheet, in order not to burn all the operations.
But, of course, this is much less fancy and still "semi-automated" ;-)
Kind regards from Germany
Idris
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!
Making That Bank. Thanks for taking the time. All the best
Been a while mate! Happy to have you back, nice haircut 💪
excellent info i needed just today. awesome!
Wow! Thank you, Nick! It’s really helpful ❤
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.
Great Video brother 😍, also lookin good with the new hairstyle 🙌🏻
Glad to have the sauce back
Woohoo! A new long form video! 🎉
Hey - you are alive, Nick! I was already worried!
finally you are back!
It’s really helpful, Thank you so... so much
Awesome :) Thanks for the tip. Does this works with multiple operations aggregation of a previous module instead of bundles ?
Could you please do a video on the bulk update a row
Hey Nick, could this be done for the high ticket email system?
life saving video! thank you nick
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 the type forms in the career sections at left click are not working
Hey thank you for the amazing video! Can you make the same thing but just for airtable?
Welcome back!
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 🤝
Clever! Hey nick i am wondering if you have developer backgorund?
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...
Super helpful. Thanks
Appreciate you Glenn 👊
@@nicksaraev gotta support local creators my dude! Love your work and love you're in Van
This is the G.O.A.T. video.
Hey man! After long time?
Terrific! Thanks!
He’s back
After a long time on youtube mate
What up bro! I've returned to plague your feed again 😈
@@nicksaraev 😅😂😂😂 extrodinary initiative bro
Love you bro
Asking much do any chance to be part of your team
Thank You so much
And he finally emerges from the ether
The ether got boring 😂 I prefer TH-cam
more open tabs please...
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
Gold🔥
He is baaack!!! 🎉 Letsss gooo!
Now let me in your Skool Community alr 🔫😅
MUITO BOM, DEMAIS
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!🫵🏻😎