About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces Zapier Canvas Zapier Chatbots

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

  • Home
  • Get Help
  • How Do I
  • How do I send monthly messages to clients with a link to their customized folder in Google Drive using Sendinblue?
Question

How do I send monthly messages to clients with a link to their customized folder in Google Drive using Sendinblue?

  • 4 May 2023
  • 1 reply
  • 14 views
tstoolbox
Userlevel 1

Hi,

I’m trying to set up an automation (if possible) between Google Drive and Sendinblue. 

 

At the moment, I send out a text/email to my contacts/clients once a month, and I want to include a link to a monthly folder where they upload their photos. Each client has their own folder, and inside that there a monthly folders from Jan-Dec.

 

When I send them a message each month, is there a way I can can customise it to include their monthly folder without having to create a new text message with that specialised folder every time? 

 

Or is there an easier solution to this problem? Any help would be great.

 

Cheers.

 

H

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

SamB
Rank
Userlevel 7
Badge +11

Hi again, @tstoolbox! What a great question! 🙂

Hmm, you could search for the relevant client folder using a Find a Folder (Google Drive) action and follow that up with a Add File Sharing Preference (Google Drive) action to generate a link to the folder that you can send to the client. 

To find the correct folder though, you’d need to also use a Formatter (Date / Time > Format) action to get the current month. To do that you’d need to use {{zap_meta_human_now}} in the Input field, that would insert the exact date/time your Zap runs.

For example: 

97b450c47324e72e6b5132e73e7aefe2.png

The above Formatter action would then take the date and time that the Zap runs and output just the current month in as Jan, Feb, Mar etc. like so:

518793b756eeffe6ba7172caf79026f1.png

You’d then select that in the Folder Name field in the second Find a Folder action:
ea1d5fde955c277f5a6564bba7f8d5fa.png

One thing to note here is that you’d likely also need to add an additional Find a Folder action before the one that searches for the specific month folder. So you’d have two Find a Folder actions, the first to locate the client folder and the second to locate the month folder within that client folder.

In order to search within the client folder found by the previous search action, on the Parent Folder field you’d need to choose the Custom value option then select the ID field (contains the ID number for the client folder that was found).

For example:

1938234ea88461bff9b8c3f99f017876.png

Hope that helps to get you pointed in the right direction. Please do keep us informed of how you get on with this! 

Terms & Conditions