- How to automatically add new Google Sheet rows every time there's a new booking in Cal.com
- 1. Set the Cal.com trigger as “New booking”
- 2. Add the "Add row to sheet" step in Google Sheets
- 3. Activate your playbook
- Learn more about integrating with Google Sheets and Cal.com
- Related blog posts
- More how-to guides featuring Google Sheets and Cal.com
How to automatically add new Google Sheet rows every time there's a new booking in Cal.com
Set the Cal.com trigger as “New booking”
Once you have finished creating your playbook, the next step would be to begin with the first action. A playbook always starts with a trigger, which is responsible for detecting changes in your connected applications and responding accordingly.
Add the Cal.com trigger to initiate your playbook's actions whenever a new Cal.com booking is made. Click "Add trigger" in your playbook and choose "New booking" from the dropdown menu under Cal.com. This will allow your playbook to automatically identify new bookings and trigger necessary actions.
If you still need to connect your Cal.com account to Relay.app yet, a prompt will guide you through the process.
Add the "Add row to sheet" step in Google Sheets
Integrate the Google Sheets automation into your playbook to ensure the prompt addition of a new Google Sheet row every time there's a new booking on Cal.com.
Click the "Add step" button, then locate the "Add row to sheet” automation for Google Sheets and input the mandatory and relevant details.
If your Google Sheets account still needs to be connected to Relay.app, you will be prompted to complete that connection. Make sure to allow the necessary permissions for Relay.app to sync with your Google Sheets account.
Activate your playbook
Activating your playbook is the last step in the process. Once you turn it on, it will automatically add new Google Sheet rows every time there's a new booking on Cal.com without requiring manual intervention.
To activate your playbook, click the toggle button at the header. Before activating, we recommend performing a test run of your playbook to ensure all the steps work seamlessly together.