Skip to main content

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”

Hi @NHSOLARECS 

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


https://prnt.sc/IkXs3jc7LXZl

This is the error.


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.


@NHSOLARECS 

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


@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


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...