Can I create a Google Drive folder and fetch its share link with automation?

[0800-grizzly]

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.

[TheTimeSavingCo · Accepted solution]

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!

[ScottWorld]

@0800-grizzly

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

[0800-grizzly]

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

[0800-grizzly]

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

[TheTimeSavingCo]

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 `&`