Zapier + Airtable + Cotter: Send User Data to Airtable using Zapier
Know who logs in to your site and get the list of user emails imported to Airtable.
How it works
When you integrated Cotter to your site and a user logs in using Cotter Login Form, Cotter will immediately create a new user for you. This user is stored in Cotter's database and can be accessed through our Zapier integration. Using Zapier, you can send user data to Airtable. The user data that are available are defined in the documentation for User object.
Create a new Base and a Table.
Add headers on the first row, like below.
Click "Make a Zap".
Under "When this happens ..." choose "Cotter" and let the trigger be "New User".
Find Data to see a test data.
If this is a new project and you do not have a user yet, you'll see "We couldn’t find an user". Create a new user in your Cotter (1.0.0) Zapier - https://zapier.com/ account and test your trigger again.
Try logging-in into your website's "Cotter Login Form" located on your login page. Use an email address that you have access to. Once the login is successful, Cotter will automatically create a new user.
Test the integration again.
Under "Do this ...", choose Airtable.
Choose action: "Create Record".
Login to the Airtable Account that you used to create the Table in the Airtable Setup section above.
Select the Base and the Table which contain the headers in the Google Sheets Setup section above.
Fill in the rest of the fields as follows:
6. Click "Continue" and then "Test & Review". You should see a row of record added to your Table.
7. If it succeeded, you can turn on the Zap and it will insert new users to your Table. (Zapier will check for new users every 2 minutes, please be patient when testing or click Run to fetch the data).
You should be able to see something like this in your Airtable.
Under the "identifier" section, you will see all emails that log in to your website (a list of your users' emails).