Skip to main content
Answer

Google Sheet to Active Campaign

  • October 30, 2024
  • 7 replies
  • 49 views

Forum|alt.badge.img

I’ve tried numerous times and watched tutorial. No error message and connection are good, but when I test and add another entry in the Goolge sheet, it doesn’t enter the designated list. Any suggestions?

 

Best answer by Mshadrick

Starting over and creating a new Zap fixed the problem. I just tested it and it worked. 

I appreciate all you help and patience. 

Thank you, Troy. 

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
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 30, 2024

Hi @Mshadrick 

Help us have more info by posting these screenshots:

  • how your Zap steps are outlined and configured in EDIT mode so we can see the field mappings
  • check your Zap Runs to see activity and details about the DATA IN/OUT for each Zap step to help you troubleshoot: https://zapier.com/app/history/

Forum|alt.badge.img
  • Author
  • New
  • October 30, 2024

Thanks for your quick response. 

I tried to check the Zap Runs under history, but there was nothing there. Here’s the screenshots. 

I’m at a loss. I’ve created other Zaps but Google sheet is being difficult. 

Thank you. 

Marisa


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 30, 2024

@Mshadrick 

Did you try publishing the Zap to turn the Zap ON, then test live?

Can you post screenshots showing how your GSheet top 3 rows are configured?

NOTE: The Zap trigger being used will fire for NEW rows AND for UPDATED rows when the specified column is updated.

I recommend adding a Filter as Zap step 2 to check there is an email address to prevent errors in the AC Zap step.


Forum|alt.badge.img
  • Author
  • New
  • October 31, 2024

Thank you for the feedback. 

I always make sure the Zap is On. If I temporarily work on the Zap, I turn it off and then back on. 

As far as a Filter, I went back to the Free plan because I typically use direct integration. 

That said, a Filter is an option but shouldn’t be the only way a Zap works. 

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • October 31, 2024

@Mshadrick 

Try duplicating the Zap.

 

Help links for using GSheets in Zaps: https://zapier.com/apps/google-sheets/help

 

Alternative is to use Airtable instead of GSheets.


Forum|alt.badge.img
  • Author
  • New
  • Answer
  • October 31, 2024

Starting over and creating a new Zap fixed the problem. I just tested it and it worked. 

I appreciate all you help and patience. 

Thank you, Troy. 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • November 1, 2024

That’s great news @Mshadrick! We’re glad to hear that recreating the Zap resolved the issue here.

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗