Zapier + Google Sheets + Cotter: Send User Data to Your Google Sheets using Zapier
Know who logs in to your site and get the list of user emails imported to Google Sheets.
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 Google Sheets. The user data that are available are defined in the documentation for User object.
Google Sheets Setup:
Create a new Google Sheets.
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.
Google Sheets Zap
Under "Do this ...", choose Google Sheets.
Choose action: "Create Spreadsheet Row".
Login to the Google Account that you used to create the Google Sheets in the Google Sheets Setup section above.
Select the Spreadsheet and the Worksheet 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 Spreadsheet.
7. If it succeeded, you can turn on the Zap and it will insert new users to your Spreadsheet. (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 Google Sheets.
Under the "identifier" section, you will see all emails that log in to your website (a list of your users' emails).