Google Calendar + Smartsheet

Google Calendar + Smartsheet integrations

Create rows in Smartsheet for new events matching search in Google Calendar

Stay organized and efficient with this workflow that creates a row in your Smartsheet whenever a new event matching your search is added in Google Calendar. This automation helps you keep track of events and tasks in an easy-to-view spreadsheet format, saving you the manual work of copying over details between the two platforms. Ideal for project management, it ensures no event falls through the cracks.

When this happens...
New Event Matching SearchTriggers when an event is created that matches a search.
TriggerPolling
automatically do this!
Add Row to SheetAdd a row to a sheet.
ActionWrite

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with Google Calendar and Smartsheet

Discover other triggers and actions you can use with Google Calendar and Smartsheet

New Calendar
Triggers when a calendar is created.
Trigger
Polling
Try It
- Calendar
  Required
- Search_term
Trigger
Polling
Try It
- Calendar
  Required
- Expand Recurring Events
Trigger
Instant
Try It
- Calendar
  Required
- Search_term
  Required
Trigger
Polling
Try It
- Name
  Required
- Description
Action
Write

- Calendar
  Required
- Summary
- Description
- Location
- Add Conferencing?
- Start Date & Time
  Required
- End Date & Time
  Required
- Repeat Frequency
- Repeat Until
- Repeat How Many Times?
- All day
- Color
- Attendees
- Visibility
- Use Default Reminders?
- Reminders
- Minutes Before Reminders
- Show me as Free or Busy
- Guests Can Modify Event
- Event Type
Action
Write
- Source Calendar
  Required
- Event
  Required
- Destination Calendar
  Required
- Send Notifications
Action
Write

- Api_docs_info
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Calendar
  Required
- Expand Recurring Events
- Search_term
- Attendee email
- Start Time Before
- End Time After
- Event Type
Action
Search
- Show Hidden Calendars
- Show Deleted Calendars
- Minimum Access Role
Action
Search
- Calendar
  Required
- Expand Recurring Events
- Search_term
- Attendee email
- Start Time Before
- End Time After
- Event Type
- Summary
- Description
- Location
- Add Conferencing?
- Start Date & Time
  Required
- End Date & Time
  Required
- Repeat Frequency
- Repeat Until
- Repeat How Many Times?
- All day
- Color
- Attendees
- Visibility
- Use Default Reminders?
- Reminders
- Minutes Before Reminders
- Show me as Free or Busy
- Guests Can Modify Event
- Event Type
Action
Search or write
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
Updated Row
Triggers when cells in a row are updated or created (based on your settings).
Trigger
Instant
Try It
- Sheet
  Required
- Row
  Required
- File Attachment
  Required
Action
Write
- Choose a Sheet
  Required
- Add Row to Top or Bottom
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Sheet
  Required
- Column
  Required
- Parent Row
Action
Write
- Destination
  Required
- Sheet to Copy
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row ID
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Format
  Required
- Email Subject
- Message
- CC Me?
- Paper Size
Action
Write
- Choose a Workspace
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
Find sheet Row (Legacy)
Find a row in a specified sheet using a query.
Action
Write
- Sheet ID
  Required
- Query
  Required
Action
Search

- Calendar
  Required
Trigger
Polling
Try It
- Calendar
  Required
- Time Before
- Time Before (Unit)
- Search_term
Trigger
Polling
Try It
- Calendar
  Required
Trigger
Instant
Try It
- Calendar
  Required
- Event
  Required
- Attendee/s
  Required
Action
Write
- Calendar
  Required
- Event
  Required
- Notify Attendees?
Action
Write
- Calendar
  Required
- Describe Event
  Required
- Attendees
Action
Write
- Calendar
  Required
- Event
  Required
- Summary
- Description
- Location
- Start Date & Time
- End Date & Time
- Repeat Frequency
- Repeat Until
- Repeat How Many Times?
- All day
- Color
- Attendees
- Visibility
- Use Default Reminders?
- Reminders
- Minutes Before Reminders
- Show me as Free or Busy
Action
Write
- Calendar
  Required
- Event ID
  Required
Action
Search
- Calendar
- Start Time
- End Time
Action
Search
- Calendar
  Required
Action
Search
Get Reports
[PRIVATE] Generates report list for dropdown.
Trigger
Polling
Try It
- Choose a Sheet
  Required
Trigger
Polling
Try It
- Select a Report
  Required
Trigger
Polling
Try It
- Workspace Name
  Required
Action
Write
- Choose a Sheet
  Required
- Row
  Required
- Title
  Required
- Comment
  Required
Action
Write
- Source Folder
  Required
- Destination Folder
  Required
- New Folder Name
  Required
Action
Write
- Workspace
  Required
- New Name
  Required
- What to Include?
- Skip Remap
Action
Write
- Choose Source Sheet
  Required
- Choose a Destination Sheet
  Required
- Choose Row
  Required
Action
Write
- Destination
  Required
- Template
  Required
- Copy Cells?
  Required
- Copy Attachments?
  Required
- Copy Discussions?
  Required
- Sheet Name
  Required
Action
Write
- Choose a Sheet
  Required
- Email Address(es)
  Required
- Choose Row
  Required
- Email Subject
- Message
- CC Me?
- Include Attachments ?
- Include Discussions ?
Action
Write
- Choose a Sheet
  Required
- Email Address(es) to Share To
  Required
- Access Level
  Required
- Notify via Email?
  Required
- Email Subject
- Message
- CC Me?
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Sheet ID
  Required
- Row ID
  Required
Action
Search

About Google Calendar

Google Calendar lets you organize your schedule and share events with co-workers and friends. With Google's free online calendar, it's easy to keep track of your daily schedule.

Learn moreLearn moreHelpHelp

Related categories

Calendar

Google

Similar apps

Appointlet

Scheduling & Booking

Acuity Scheduling

Scheduling & Booking

Microsoft Office 365

Email, Microsoft

About Smartsheet

Smartsheet is a leading cloud-based platform for work execution, enabling teams and organizations to plan, capture, manage, automate, and report on work at scale, resulting in more efficient processes and better business outcomes.

HelpHelp

Related categories

Spreadsheets

Similar apps

MySQL

Databases

Zoho Creator

App Builder, Zoho

Knack

Databases

Google Calendar + Smartsheet

Google Calendar + Smartsheet

Create rows in Smartsheet for new events matching search in Google Calendar

More things you can do with Google Calendar and Smartsheet

Related Zap Templates

Related Zap Templates