Integrate Notion and Google Sheets to automate workflows with scalable backend
Connect Notion and Google Sheets nodes to in your workflow. Integrate with any tool or database and ship powerful backend logic and APIs instantly - No code required!
Getting Started
How To Connect Notion and Google Sheets
Popular Templates With Notion and Google Sheets
Explore our popular Google Sheets & templates below. Click. Remix. Ship!
🤖
Azure - Chat with GSheets
Make an Assistant that access to a google sheets to respond
🤖
Claude - Chat with GSheets
Make a Claude Assistant that access to a google sheets to respond.
📊
JSON to Google Sheets
Seamlessly import JSON data into a Google Sheet, with the flexibility to choose specific fields for insertion.
🗣️
Audio Translator
Given speech audio, transcribe it, translate it into the target language, and finally convert it back to speech using Google's translation and text-to-speech APIs.
Google Translate
🛋️
Chat with GSheets
Make an Assistant that access to a Google Sheets to respond. This template showcases an online furniture store.
OpenAI
BuildShip database
GSheets
🧐
Data Analyst
Recruit a new data analyst for your research. Give it access to your data in a spreadsheet and ask it questions. It can handle different responses like online surveys, user interviews or market rese...
OpenAI
GSheets
👁️
Google Vision - Text Detection
Given an image, find the text in it using Google Vision.
Google Vision
Node stack
Supported Triggers & Actions
Notion NODES
Append Blocks to Page
A block object represents a piece of content within Notion. The API translates the headings, toggles, paragraphs, lists, media, and more that you can interact with in the Notion UI as different block type objects. (https://developers.notion.com/reference/block)
Create Comments
Creates a comment in a page or existing discussion thread.
Create Notion Access Token
Creates an access token for third-party service authentication with Notion
Create Page
Creates a new page that is a child of an existing page or database using OAuth
Creates a database as a subpage
Creates a database as a subpage in the specified parent page, with the specified properties schema. Currently, the parent of a new database must be a Notion page or a wiki database.
Fetch Page
Retrieve a Notion page using OAuth.
Fetch Page Blocks
A block object represents a piece of content within Notion. The API translates the headings, toggles, paragraphs, lists, media, and more that you can interact with in the Notion UI as different block type objects. (https://developers.notion.com/reference/block)
List Users
Lists all users in a Notion workspace
script
Query Database
Gets a list of Pages and/or Databases contained in the database, filtered and ordered according to the filter conditions and sort criteria provided in the request using OAuth
script
Retrieve Comments
Retrieves a list of un-resolved Comment objects from a page or block via OAuth
script
Retrieve Database
Retrieves a database object — information that describes the structure and columns of a database — for a provided database ID.
script
Search By Title
Performs a search on Notion for a given title through all the parent and child pages using OAuth
script
Update Block
Updates the content for the specified `block_id` based on the block type.. Official Documentation - [here](https://developers.notion.com/reference/update-a-block)
script
Update Database
Updates Notion database. Retrieves a database object — information that describes the structure and columns of a database via OAuth
script
Update Notion Page
Updates the properties of a page in a database. Official Documentation - [here](https://developers.notion.com/reference/patch-page)
script
Google Sheets NODES
Add Row
Adds row(s) of data in a Google Sheet.
script
Batch Update Sheet
Batch updates values in a Google Sheet. This node is technically a bit complex to entertain more versatile use cases. To simply add values to a Google Sheet, check out the "Add Row" node.
script
Create Sheet
Creates a new Google Spreadsheet.
script
Get Sheets
Fetch a Google Spreadsheet using the Google Sheets API
script
Blog posts & Tutorials
Recommended
Reads
Below are recommneded blogs that will help in your journey
Support
Need Help?
Here are some helpful resources to get you "unstuck"
💬
Join BuildShip Community ->
An active and large community of no-code / low-code builders. Ask questions, share feedback, showcase your project and connect with other BuildShip enthusiasts.
🙋
Hire a BuildShip Expert ->
Need personalized help to build your product fast? Browse and hire from a range of independent freelancers, agencies and builders - all well versed with BuildShip.
🛟
Send a Support Request ->
Got a specific question on your workflows / project or want to report a bug? Send a us a request using the "Support" button directly from your BuildShip Dashboard.
⭐️
Feature Request ->
Something missing in BuildShip for you? Share on the #FeatureRequest channel on Discord. Also browse and cast your votes on other feature requests.