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.

Here's an example of how the report will come,

This one doesn't have the email address,

It looks like the formatting might make it hard to upload directly into mailchimp with an automation?

If so we might need step 2 to be some app script automation that when a file is added to the drive folder it cleans up the formatting ready for upload.

The process end to end should look like this:

1) We get their sales system to send us a daily report of prospects, members, last activity dates etc. Each time it will be a new spreadsheet.

2) The file automatically gets saved to google drive

2.1) If we need to fix the format ready for upload then an google app script might be needed

3) The file is then automatically imported into mailchimp where it has to Add New Subscribers or Update existing Subscribers

Hi @wholeofthemoonamarketing 

We would need to see screenshots with how the spreadsheet is formatted to have more context.

It may involve using the GSheet API via one of these advanced actions:

  • Custom Action
  • API Request

Hey @Troy Tessalone So, Iam planning to change the flow.

So, what I wanted to happen is 

Zap that uploads the CSV file directly to mailchimp and either adds any new records or updates existing records.

@wholeofthemoonamarketing 

Try using Files by Zapier: https://zapier.com/apps/files-by-zapier/integrations#triggers-and-actions

 

 

Sorry but can you help me on this part? with the csv files I receive, there are multiple subscribers rather than just 1.

My thinking is that each report (email received with csv file) will update the status of members, so the main thing will be to make sure we have mapped accurately the fields that represent the changes in an individual's relationship to the gym.

So for example when a prospect becomes a member they are no longer listed as a prospect etc

@wholeofthemoonamarketing 

How many records MAX can there be in the CSV?

Not really sure but probably hundreds.

I did see a similar post 8 months ago so I was thinking if it’s already possible to add/update multiple record rather than just have 1?

@wholeofthemoonamarketing 

Try these Zap steps:

 

Zap 1

  1. Trigger: Gmail - New Attachment
  2. Action: Files by Zapier - Trigger Zap from CSV Rows
    1. Use the webhook url from Zap 2, Step 1

 

Zap 2

  1. Trigger: Webhook - Catch Hook
    1. Put the webhook url in Zap 1, Step 2
  2. Action: Mailchimp - Add/Update Subscriber

Hello do you have any recommendation aside from Files as it seems that it’s not supported anymore

 

@wholeofthemoonamarketing 

Files by Zapier can only be used as a Zap action step:

https://zapier.com/apps/files-by-zapier/integrations#triggers-and-actions

Yes just as I did here

 

@wholeofthemoonamarketing 

Gmail accounts that are not paid have limitations for being used in Zaps.

Click the link to learn more.

 

Terms & Conditions