Skip to main content
Question

How do I import a CSV file from Constant Contact to create records in a Zapier Table?

  • January 21, 2024
  • 6 replies
  • 28 views

How do I import a CSV file to create records in a Zapier Table

my clients will fill in a form sent from Constant Contact and I can export this CSV:

I want to write a record to a Zapier Table, and I can rearrange the columns, but if I try to import a properly-formatted CSV file, it says it’s “not a valid file”

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

6 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34043 replies
  • January 21, 2024

Hi @NHSOLARECS 

Can you post screenshots with the encountered errors and steps you took before to give us more context?


  • Author
  • New
  • 3 replies
  • January 21, 2024

  • Author
  • New
  • 3 replies
  • January 21, 2024

I’m trying a few different approaches.

I created a Form in Zapier that has input boxes for the info I need, but I don’t know how to send it out.

I want the trigger to be

When a client fills out the form and submits it, write the info into a row in a Google Sheets spreadsheet.


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34043 replies
  • January 21, 2024

@NHSOLARECS 

If you are having trouble with the CSV import to Zapier Tables, you can try opening a ticket here: https://eap.zapier.app/


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • 34043 replies
  • January 21, 2024

@NHSOLARECS 

Some options:

 

You can use a GForm and link it to a GSheet, no Zap needed.

https://support.google.com/docs/answer/2917686?hl=en

 

You could use Airtable which has Form Views: https://support.airtable.com/docs/getting-started-with-airtable-form-views

 

If you’re trying to use a Zap, then check out these app triggers/actions:

Zapier Interfaces: https://zapier.com/apps/interfaces/integrations#triggers-and-actions

Zapier Tables: https://zapier.com/apps/zapier-tables/integrations#triggers-and-actions


  • Author
  • New
  • 3 replies
  • January 21, 2024

thank you...but of course, right in the middle of this convo, i have drive my granddaughter to work…

I will follow your suggested links when I return...