How to integrate Google Sheets – Google Calendar bundle using Zapier?

Automatically create Google Calendar events from new Google Sheets rows with a simple Zapier setup. This integration improves efficiency and keeps your schedule up to date.

Creating a new calendar event when a new row is added to the spreadsheet

How the integration works:

• A new row is created on the specified spreadsheet on Sheets
• Zapier creates a new calendar event on Google Calendar

1. On the “Home” tab, click on “Create”

2. In the dropdown menu, select “Zaps”

Setting up the trigger event

3. Trigger event is the event that occurs in the target app and informs Zapier to start the Zap.

4. Select the trigger event app

5. In the dropdown menu, select “New Spreadsheet Row” and click on “Continue”. This way, the trigger will only activate when a new spreadsheet row is created

6. Select your Google account and click “Continue”

7. Fill out the required fields and click on “Continue”

8. Test the trigger by clicking on the corresponding button

9. If everything is correct, the system should display all the information. Click on “Continue with selected record”

Setting up the action in Google Calendar

10. Select the target app

11. Select “Create Detailed Event” as an action to do when a new spreadsheet row is created

12. Select your Google account and click “Continue”

13. Fill out the required fields and click “Continue

14. Test the connection between Google Sheets and Google Calendar

15. Click “Publish”

16. After that, the Zap is now created, set up and working.