This is the continuation of a previous tutorial about exporting WhatsApp groups to Google Sheets using Zapier.
In this edition, we will be not only exporting the groups but also their participants so that we can keep a record of every single person that is or was part of a WhatsApp group.
- A Zapier account.
- A 2Chat account with your WhatsApp number connected to it.
Working the Zap
- We configure the zap to trigger every day at 9 am, but you can choose any other frequency or even change this main trigger entirely.
- We now need to select the WhatsApp group we would like to export. If you would like to export all of your groups, you would have to repeat this tutorial for each of the groups.
- Finally, we loop through each participant and insert or update their corresponding rows in Google Sheets.