Skip to main content
Solved

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

  • August 19, 2024
  • 5 replies
  • 140 views
0
Forum|alt.badge.img+17

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.

Best answer by TheTimeSavingCo

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!

5 replies

TheTimeSavingCo
Forum|alt.badge.img+31
  • TheTimeSavingCo
  • Brainy
  • 6410 replies
  • Answer
  • August 19, 2024

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!

Adam, Airtable Consultant - thetimesaving.company
ScottWorld
Forum|alt.badge.img+35
  • ScottWorld
  • Genius
  • 9770 replies
  • August 19, 2024

@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

0
Forum|alt.badge.img+17
  • 0800-grizzly
  • Author
  • Known Participant
  • 61 replies
  • August 20, 2024

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!


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

0
Forum|alt.badge.img+17
  • 0800-grizzly
  • Author
  • Known Participant
  • 61 replies
  • August 20, 2024

@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


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
Forum|alt.badge.img+31

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


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

Adam, Airtable Consultant - thetimesaving.company


Terms & ConditionsAccessibility statement