Google Sheets + Notion
Format Google Sheets cells when Notion item properties update
Create a seamless workflow between your Notion and Google Sheets data. With this, every time you update properties in a Notion data source item, the corresponding cell range in Google Sheets is immediately formatted. It's a smart way to maintain consistency across your assets, saving you considerable manual work and boosting scalability possibilities.
Create a seamless workflow between your Notion and Google Sheets data. With this, every time you update properties in a Notion data source item, the corresponding cell range in Google Sheets is immediately formatted. It's a smart way to maintain consistency across your assets, saving you considerable manual work and boosting scalability possibilities.
- When this happens...
Updated Properties in Data Source ItemTriggers when one or more properties of a data source item are updated.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Format Cell RangeApply date, number, or style formatting (colors, bold, italic, strikethrough) to a range of cells in a Google Sheets spreadsheet.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Database
Data Source
Page
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.PageRequired
Block TypeRequired
Content
Programming Language
Checked
Icon (Emoji)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PageRequired
CommentRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Parent PageRequired
Title
Content
Icon
Cover
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Item IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Data Source
ItemRequired
Content
Content Format
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Retrieve a Page
This action retrieves a specific page from Notion using its ID. The page id can be a normal page or a database item.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PageRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appBlock IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPage IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appTitleRequired
Exact MatchRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appData Source
Advanced Query (JSON)
ActionThis is an event a Zap performs.SearchFind existing data in your appData Source
Template Mode
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup columnRequired
Lookup valueRequired
Supporting lookup column
Supporting lookup value
Search from last row
Row count
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
Data Source
PageRequired
Properties to Watch
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Data Source
ItemRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Data Source
Template Mode
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.PageRequired
ContentRequired
Content Format
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DatabaseRequired
Title
Move To
Display Inline
Icon (Emoji)
Move to Trash
Lock Database
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Data SourceRequired
Title
Icon Emoji
Property Updates (JSON)
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Retrieve Database
This action retrieves a database in Notion using the ID of the database.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Block IdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appData Source
ActionThis is an event a Zap performs.SearchFind existing data in your appBlock IDRequired
Page Size
Start Cursor
ActionThis is an event a Zap performs.SearchFind existing data in your appPage or Database Item IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appPageRequired
PropertyRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appUserRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
About Notion
A new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.
Related categories
Related Zap Templates
- Add items to Notion databases from new rows in Google Sheets
- Generate Google Sheets rows for new items in Notion databases
- Send items to databases in Notion from new or updated Google Sheets rows
- Update Google Sheets rows when Notion database items are updated
- Update Notion databases with new or updated Google Sheets rows
- Save new or updated Google Sheets (Team Drive) rows in Notion databases
- Create Notion database items from new Google Sheets rows
- Generate rows in Google Sheets for new database items in Notion
- Generate Notion database items from new or updated Google Sheets rows
- Create spreadsheets in Google Sheets for new database items in Notion
- Add items to Notion databases with new rows in Google Sheets (Team Drive)
- Create Google Sheets rows for new Notion database items
- Create database items in Notion from new Google Sheets rows (Team Drive)
- Add new Notion database items to Google Sheets row(s)
- Create Google Sheets rows for new Notion database items
- Create Google Sheets Rows for New Notion Database Items
- Update Notion database items with new Google Sheets rows.
- Copy worksheets for new Notion database items.
- Create Notion pages from new Google Sheets spreadsheets.
- Create Notion pages from new Google Sheets rows.
- Update Notion database items when new Google Sheets rows are added
- Create Notion pages from new Google Sheets spreadsheets
- Create Notion pages from new or updated Google Sheets rows
- Create spreadsheet columns in Google Sheets for new database items in Notion
- Create Notion database items from new Google Sheets rows
- Create Notion pages from new Google Sheets rows
- Update Google Sheets rows when new Notion database items are added
- Create worksheets in Google Sheets for new Notion database items
- Create Notion pages from new or updated Google Sheets rows in team drive
- Update Google Sheets rows with new Notion database items
- Update Google Sheets rows whenever updated Notion database items occur
- Update Google Sheets rows with each updated Notion database item
- Copy worksheets in Google Sheets when database items are updated in Notion
- Update Notion database items with new or updated rows from Google Sheets team drive
- Create Google Sheets spreadsheets from updated Notion database items
- Create new Google Sheets worksheets from updated Notion database items
- Create new Notion database items from new Google Sheets worksheets
- Create multiple Google Sheets rows from updated Notion database items
- Update Notion app extensions when new or updated rows are added in Google Sheets
- Update Google Sheets with custom actions when Notion database items are updated
- Create rows in Google Sheets for new database items in Notion utilizing custom actions (beta)
- Update Notion actions based on new or updated rows in Google Sheets team drive
- Update Google Sheets rows every time Notion database items are updated
- Create multiple spreadsheet rows in Google Sheets from updated database items in Notion
- Update Google Sheets worksheets with each updated Notion database item
- Create Google Sheets rows from updated Notion database items
- Update Google Sheets rows with updated Notion database items
- Update Notion database items with new or updated rows from Google Sheets team drive
- Clear Google Sheets rows with updated Notion database items
- Create new Notion pages from new Google Sheets worksheets
- Update database items in Notion when new worksheets are created in Google Sheets
- Add new Google Sheets rows to Notion pages
- Update Notion pages with content from new or updated Google Sheets rows
- Update database items in Notion when new spreadsheets are created in Google Sheets
- Update multiple spreadsheet rows in Google Sheets when pages are updated in Notion
- Update Notion database items when new rows are added to Google Sheets team drive
- Create new Google Sheets rows from updated Notion pages
- Add content to Notion pages for new or updated Google Sheets rows on team drive
- Create Google Sheets columns from updated Notion pages
- Create worksheets in Google Sheets from updated pages in Notion
- Update Google Sheets rows when Notion database items are updated
- Create Notion database items from new or updated Google Sheets rows
- Clear spreadsheet rows in Google Sheets when new database items appear in Notion
- Create spreadsheets in Google Sheets from updated pages in Notion
- Create multiple spreadsheet rows in Google Sheets for new database items in Notion
- Create spreadsheet rows in Google Sheets for new database items in Notion
- Create Notion database items from new or updated rows in Google Sheets
- Update Notion database items with new or updated rows from Google Sheets team drive
- Create new Notion database items from new Google Sheets rows
- Create new Notion database items from new Google Sheets spreadsheets
- Create new Notion database items from new rows in Google Sheets team drive
- Create worksheets in Google Sheets from updated pages in Notion
- Create spreadsheet rows in Google Sheets for updated database items in Notion
- Update Notion database items with new or updated rows from Google Sheets
- Create Notion pages from new or updated rows in Google Sheets
- Update Google Sheets rows when Notion database items are updated
- Update Google Sheets rows when Notion pages are updated
- Update Google Sheets rows whenever Notion database items are updated
- Add new Google Sheets spreadsheets content to Notion pages instantly
- Retrieve databases in Notion from new or updated spreadsheet rows in Google Sheets
- Create Google Sheets rows at the top for new Notion database items
- Capture updated Notion items by creating new rows at top in Google Sheets
- Create spreadsheets in Google Sheets from new comments in Notion
- Create spreadsheet rows in Google Sheets for every new comment in Notion
- Add comments in Notion for new or updated rows in Google Sheets
- "retrieve Notion pages when new or updated rows are added to Google Sheets on team drive"
- Archive Notion database items when new or updated rows appear in Google Sheets
- Archive Notion items when new rows are added to Google Sheets
- Add new Google Sheets rows to Notion page content
- Add comments in Notion for new rows in Google Sheets
- Update Google Sheets properties when new Notion database items are created
- Add blocks to Notion pages from new or updated rows in Google Sheets
- Add blocks to Notion pages from new rows in your team drive Google Sheets
- Update Notion databases when new or updated rows are added in Google Sheets
- Create a copy of worksheets in Google Sheets for every new comment in Notion
- Update Notion databases when new Google Sheets rows are added
- Create Google Sheets rows from new Notion data source items
- Update Google Sheets properties each time new data source items are added in Notion
- Update Google Sheets when property changes in Notion items occur
Related Zap Templates
- Add items to Notion databases from new rows in Google Sheets
- Update Google Sheets rows when Notion database items are updated
- Create Notion database items from new Google Sheets rows
- Create spreadsheets in Google Sheets for new database items in Notion
- Create database items in Notion from new Google Sheets rows (Team Drive)
- Create Google Sheets Rows for New Notion Database Items
- Create Notion pages from new Google Sheets spreadsheets.
- Create Notion pages from new Google Sheets spreadsheets
- Create Notion database items from new Google Sheets rows
- Create worksheets in Google Sheets for new Notion database items
- Update Google Sheets rows whenever updated Notion database items occur
- Update Notion database items with new or updated rows from Google Sheets team drive
- Create new Notion database items from new Google Sheets worksheets
- Update Google Sheets with custom actions when Notion database items are updated
- Update Google Sheets rows every time Notion database items are updated
- Create Google Sheets rows from updated Notion database items
- Clear Google Sheets rows with updated Notion database items
- Add new Google Sheets rows to Notion pages
- Update multiple spreadsheet rows in Google Sheets when pages are updated in Notion
- Add content to Notion pages for new or updated Google Sheets rows on team drive
- Update Google Sheets rows when Notion database items are updated
- Create spreadsheets in Google Sheets from updated pages in Notion
- Create Notion database items from new or updated rows in Google Sheets
- Create new Notion database items from new Google Sheets spreadsheets
- Create spreadsheet rows in Google Sheets for updated database items in Notion
- Update Google Sheets rows when Notion database items are updated
- Add new Google Sheets spreadsheets content to Notion pages instantly
- Capture updated Notion items by creating new rows at top in Google Sheets
- Add comments in Notion for new or updated rows in Google Sheets
- Archive Notion items when new rows are added to Google Sheets
- Update Google Sheets properties when new Notion database items are created
- Update Notion databases when new or updated rows are added in Google Sheets
- Create Google Sheets rows from new Notion data source items
- Generate Google Sheets rows for new items in Notion databases
- Update Notion databases with new or updated Google Sheets rows
- Generate rows in Google Sheets for new database items in Notion
- Add items to Notion databases with new rows in Google Sheets (Team Drive)
- Add new Notion database items to Google Sheets row(s)
- Update Notion database items with new Google Sheets rows.
- Create Notion pages from new Google Sheets rows.
- Create Notion pages from new or updated Google Sheets rows
- Create Notion pages from new Google Sheets rows
- Create Notion pages from new or updated Google Sheets rows in team drive
- Update Google Sheets rows with each updated Notion database item
- Create Google Sheets spreadsheets from updated Notion database items
- Create multiple Google Sheets rows from updated Notion database items
- Create rows in Google Sheets for new database items in Notion utilizing custom actions (beta)
- Create multiple spreadsheet rows in Google Sheets from updated database items in Notion
- Update Google Sheets rows with updated Notion database items
- Create new Notion pages from new Google Sheets worksheets
- Update Notion pages with content from new or updated Google Sheets rows
- Update Notion database items when new rows are added to Google Sheets team drive
- Create Google Sheets columns from updated Notion pages
- Create Notion database items from new or updated Google Sheets rows
- Create multiple spreadsheet rows in Google Sheets for new database items in Notion
- Update Notion database items with new or updated rows from Google Sheets team drive
- Create new Notion database items from new rows in Google Sheets team drive
- Update Notion database items with new or updated rows from Google Sheets
- Update Google Sheets rows when Notion pages are updated
- Retrieve databases in Notion from new or updated spreadsheet rows in Google Sheets
- Create spreadsheets in Google Sheets from new comments in Notion
- "retrieve Notion pages when new or updated rows are added to Google Sheets on team drive"
- Add new Google Sheets rows to Notion page content
- Add blocks to Notion pages from new or updated rows in Google Sheets
- Create a copy of worksheets in Google Sheets for every new comment in Notion
- Update Google Sheets properties each time new data source items are added in Notion
- Send items to databases in Notion from new or updated Google Sheets rows
- Save new or updated Google Sheets (Team Drive) rows in Notion databases
- Generate Notion database items from new or updated Google Sheets rows
- Create Google Sheets rows for new Notion database items
- Create Google Sheets rows for new Notion database items
- Copy worksheets for new Notion database items.
- Update Notion database items when new Google Sheets rows are added
- Create spreadsheet columns in Google Sheets for new database items in Notion
- Update Google Sheets rows when new Notion database items are added
- Update Google Sheets rows with new Notion database items
- Copy worksheets in Google Sheets when database items are updated in Notion
- Create new Google Sheets worksheets from updated Notion database items
- Update Notion app extensions when new or updated rows are added in Google Sheets
- Update Notion actions based on new or updated rows in Google Sheets team drive
- Update Google Sheets worksheets with each updated Notion database item
- Update Notion database items with new or updated rows from Google Sheets team drive
- Update database items in Notion when new worksheets are created in Google Sheets
- Update database items in Notion when new spreadsheets are created in Google Sheets
- Create new Google Sheets rows from updated Notion pages
- Create worksheets in Google Sheets from updated pages in Notion
- Clear spreadsheet rows in Google Sheets when new database items appear in Notion
- Create spreadsheet rows in Google Sheets for new database items in Notion
- Create new Notion database items from new Google Sheets rows
- Create worksheets in Google Sheets from updated pages in Notion
- Create Notion pages from new or updated rows in Google Sheets
- Update Google Sheets rows whenever Notion database items are updated
- Create Google Sheets rows at the top for new Notion database items
- Create spreadsheet rows in Google Sheets for every new comment in Notion
- Archive Notion database items when new or updated rows appear in Google Sheets
- Add comments in Notion for new rows in Google Sheets
- Add blocks to Notion pages from new rows in your team drive Google Sheets
- Update Notion databases when new Google Sheets rows are added
- Update Google Sheets when property changes in Notion items occur