In our previous Zapier tutorial we walked you through how to create a Zap with Slack that messages you whenever a video call has been recorded.

That post just scratched the surface of what you can do with Zapier. In this tutorial we will walk through how you can keep track of your video calls by creating a Zap that integrates with Google Sheets.


Of course, you'll need accounts with Zapier, and Google. All of them are free, so sign up as needed.

Step-by-step tutorial

1) Log in to your Zapier account and click on the Make a Zap button.

Click Make a Zap to get started :)

2) Next you'll connect Note: our app may still be pending approval for the public Zapier app store. You can still create your Zap! Just join our app via this invitation link, 3) Create a Trigger by choosing the app. You may need to search the App Store.

Choose the app to create your Trigger.

4) Select the New Recording Trigger.

Our app has two Triggers, choose New Recording for the purpose of this tutorial

5) Connect your account with Zapier. This is very simple and free! We just need to get your API key, first. An API is a tool that lets you connect different services. Your API key will alert Zapier when a new recording has been created. To get your key: - Login to your dashboard and copy your API key from the Developers tab. - In Zapier, click the Connect an Account and paste your API key and click to continue.

Connecting with Zapier

6) Test your Trigger. Your account must have a recording for this to work. See Step 6 from our Zapier/Slack tutorial to learn how to quickly create a recording to test.

7) Add an Action Step by choosing Google Sheets from the App Store. Again, you may need to search to find the Google Sheets app.

8) Select the Create Spreadsheet Row Action. You can experiment with the other actions, yet we will update a row in an existing spreadsheet.

Choose the Create Spreadsheet Row action

9) Connect your Google Account.

10) Choose a Google Sheet to update and fill in the required fields.

Choose the Google Spreadsheet you'd like to update

11) Link the spreadsheet with the values from the API. Click on the menu icon to the right of each form and select the appropriate fields. If you are using the spreadsheet copy provided above, the fields are linked as follows (Google Sheet title → API endpoint): - Room name → Room name - Recording link → Download link - Call Duration → Duration - Number of Participants → Max Participants

Customize your spreadsheet by linking the API

12) Test your Zap! Zapier will send a test to your Google Spreadsheet. If all goes well you should see a new row created in your spreadsheet.

Success! A spreadsheet updated via Zapier :)

13) Name and turn on your Zap!

That's it! Zapier may seem overwhelming at first, yet if you've followed the simple steps above you'll have a Google spreadsheet that is updated in the background whenever a room is recorded.

What's next? Good question. Take what you've learned in this post and create a new Zap using our Zapier integration. We're excited about the powerful connections that Zapier offers users. As always, email us with any questions or comments.