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 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 set up a Zap to automatically update an Excel file on OneDrive from the Brevo campaign's corrected data?
Question

How do I set up a Zap to automatically update an Excel file on OneDrive from the Brevo campaign's corrected data?

  • 1 September 2023
  • 7 replies
  • 107 views
Sebastiaan Mathas

Hey community!

Im completely new to this app. I created a zap where when a campaign in Brevo get's sent it should push the data to an excell file on my one-drive, during the test this works fine. However when I just send a test campaign to see if it works it didnt. Also Im wondering will the data stay updated if clicks and views increase or does the zap only trigger once?

Im looking for a way to keep this excell file updated with the latest data instead of needing to do this manually.

You guys got any tips on the right settings etc?

Best regards,

Sebastiaan Mathas​​​​​​​

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

7 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @Sebastiaan Mathas 

Good question.

We would need to see detailed screenshots with how your Zap steps are configured to have enough context.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Sebastiaan Mathas

 

 

 

 

 

 

 

 

I hope the screenshots explain a little what Im trying to do. However because the trigger is sent the data only gets pushed then right? While actually it would be better if the data gets pushed constantly after the campaign has been sent so that the data is up-to-date. Im not sure if this then is the best way to do it, maybe somebody knows how best to achieve this. 

 

Thanks for the help!


Best regards,

Troy Tessalone
Userlevel 7
Badge +14

@Sebastiaan Mathas 

Zaps trigger while ON for new data going forward that fires Step 1.

The Zap trigger is for Brevor New Campaign Status, which you’ve set to Sent.

Can you elaborate more about which data you are trying to have continually updated from Brevo to the GSheet? (perhaps provide a specific example)

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Sebastiaan Mathas

An example of the data we want to sent to the sheet from the campaign is: 

 

 

Since after send the numbers of "opens" and "clicks" can still change I'd like them to be continuesly updated. And Im sending it to Excel not to a Google Sheet, not sure if that makes a difference. 

Troy Tessalone
Userlevel 7
Badge +14

@Sebastiaan Mathas

You’d likely have to use the Brevo API to get Campaign stats: https://developers.brevo.com/reference

 

 

You may need separate Zaps for deriving different data points.

You can try using this Zap action: Brevo - App Extensions

There is an AI assist that can help configure the action.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Sebastiaan Mathas

Dear Troy,

Thank you for your reply and recommendation. The API you suggested is for Mailchimp, however Im using the API that is meant for Brevo since that is the e-mailmarketing service Im using. Could the Mailchimp API work for Brevo as well, is that what you're saying? 

Im new to this, and not that technical so if programming is needed I'll need to get the IT-department to give me a hand…

Thanks again for the input?

Best regards,

Sebastiaan

Troy Tessalone
Userlevel 7
Badge +14

@Sebastiaan Mathas 

Updated my previous post to correct it for Brevo.

You’ll probably need to get your IT team involved to use the Brevo API.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions