Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Aug 19, 2024 05:50 AM
Hi,
Our process includes creating hundreds of Google Drive folders for client sharing during a year. This is now done manually, and I am looking at automating it if possible. Ideally a trigger in Airtable would the use some information identifying the client, create a Google Drive folder, make the access "Anyone with the link", fetch that link back to Airtable, and send out an email to the client.
Alternatively, Airtable would be watching a specified Google Drive directory for creation of new directories, then initiate the process of changing access and pushing the link to Airtable.
Any ideas?
Rgds,
Björn
PS. We use Zapier, so that is a viable option for us. For cost and maintenance reasons I'd like to avoid other 3rd party systems.
Solved! Go to Solution.
Aug 19, 2024 06:50 AM
re: Ideally a trigger in Airtable would the use some information identifying the client, create a Google Drive folder, make the access "Anyone with the link", fetch that link back to Airtable, and send out an email to the client.
Yeap, I've done this exact thing before with Zapier, works fine!
Aug 19, 2024 06:50 AM
re: Ideally a trigger in Airtable would the use some information identifying the client, create a Google Drive folder, make the access "Anyone with the link", fetch that link back to Airtable, and send out an email to the client.
Yeap, I've done this exact thing before with Zapier, works fine!
Aug 19, 2024 02:52 PM
Yes, you can use either Zapier or Make to do either of those 2 different methods that you said you would like to do.
If you'd like to save money & gain power, I always recommend to everybody that they should think about switching away from Zapier to Make, because it is SIGNIFICANTLY cheaper than Zapier, yet it is INFINITELY more customizable & INFINITELY more powerful.
I wrote an entire post here comparing Make vs. Zapier: https://air.tableforums.com/t/make-vs-zapier/737
— ScottWorld, Expert Airtable Consultant
Aug 20, 2024 12:09 AM - edited Aug 20, 2024 12:18 AM
Thanks @TheTimeSavingCo, got this working easily!
One follow-up question: I couldn't get Zapier's search formula for looking for several fields in Airtable to work.
This is the formula I'd like to to have for now:
{Sähköposti}="{{254014963__title}}"&{Projektin status}="Työn alla"
Tested separately both {Sähköposti}="{{254014963__title}}" and {Projektin status}="Työn alla", so I suspect it my combining them with an ampersand that doesn't work. I get "no results found" with the full combination.
@TheTimeSavingCo, can you find the error in this?
Björn
Aug 20, 2024 12:10 AM
Thank you @ScottWorld. I have followed your praise for Make, but have gotten used to Zapier so will stay there until something forces me to decide differently.
Rgds,
Björn
Aug 20, 2024 02:42 AM
Ah, try:
AND({Sähköposti}="{{254014963__title}}",{Projektin status}="Työn alla")
It expects you to use Airtable's formula syntax, and so we use `AND()` instead of `&`