Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

Question

Google Sheets > Brevo: Updating contact information in Google Sheets, not updating in Brevo

tstoolbox

I’m looking to set an automation from Typeform > Google Sheets > Brevo. When clients fill out the Typeform survey, it inputs their customer information into the Google Sheets, which then goes into Brevo as well.

 

I already have one set up, however I’m looking to have it set up so it automatically updates in Brevo if I change any information in the google sheets document.

 

Example: My clients Client receives SMS messages on Monday and Wednesday (set up as a column) . I go into Google sheets and update information as they have told me that to just want to receive it on Tuesday and Friday now. 

 

I have set up all the segments in Brevo, and they are all working when I input a new contact, however, i’ve tried updating the sheet to see what will happen but it doesn’t seem to be working. 

 

Have I set this up wrong?

 

 

 

 

 

 

 

Did this topic help you find an answer to your question?

5 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @tstoolbox 

Good question.

Try this Zap trigger: GSheets - New/Updated Row

 

 

“New or Updated Spreadsheet Row” trigger behavior

If you’re using the New or Updated Spreadsheet Row trigger and choose Any column to monitor, any change to a row will trigger your Zap. If you select a specific column, then the Zap will only trigger when there are changes on that column.

Note

Zaps using New or Updated Spreadsheet Row will also trigger for any new rows in the spreadsheet, even if the specified column is blank. To avoid triggering in those cases, add a Filter step to your Zap.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
tstoolbox
  • tstoolboxBeginner
  • Author
  • Beginner
  • 2 replies
  • July 16, 2023

Thanks Troy!

I tried placing this 3rd in the workflow.

 

I updated some information in the spreadsheet in google sheets and then re-ran the zap, however it changed the changes i made back to the original text. I assume the zap is still drawing the information from the initial typeform response?

 

However, i want to be able to change that information in the google sheet if i need to, and for that to save/update in Google Sheets, and then update in Brevo.

 

Could you please run me through how I can set that up? Does the updated google sheets action have to come after the Brevo contact list? Or have i just set it up incorrectly.

 

Cheers,

 

Harry

2 Attachments
Troy Tessalone
Forum|alt.badge.img+14

@tstoolbox 

The attachments failed to upload.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
tstoolbox
  • tstoolboxBeginner
  • Author
  • Beginner
  • 2 replies
  • July 16, 2023

 

Troy Tessalone
Forum|alt.badge.img+14

@tstoolbox 

We would need to see detailed screenshots with how each action step is configured.

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

Reply


Terms & Conditions