Integrate Google Sheets and OpenAI to automate workflows with scalable backend
Connect Google Sheets and OpenAI 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 Google Sheets and OpenAI
Popular Templates With Google Sheets and OpenAI
Explore our popular Google Sheets & templates below. Click. Remix. Ship!
🧘🏻
Meditate GPT
Generate a fully AI-driven meditation session, complete with a relaxing background and calming voiceovers to help you achieve a state of deep relaxation and mindfulness.
Replicate ElevenLabs
🛋️
Chat with Google Sheets
Create an AI Assistant that can chat with your data on Google Sheets. This template is connected to a Furniture store's inventory data on Google Sheets and users can chat with the...
OpenAI Google Sheets
🗣️
Audio Transcribe & Translate
Given a speech audio file, this template transcribes it and then translates it into a target language. This includes creating an output audio file in the target language using Goog...
Google Translate OpenAI
🤖
Chat with Airtable
Create an AI Assistant that can chat with your data on Airtable.
OpenAI Airtable
🤖
Chat with Supabase
This template enables natural conversation with your Supabase database using AI, allowing you to query and understand your data without writing SQL.
Supabase OpenAI
Node stack
Supported Triggers & Actions
Google Sheets NODES
Add Row
Adds row(s) of data in a Google Sheet.
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.
Create Sheet
Creates a new Google Spreadsheet.
Get Sheets
Fetch a Google Spreadsheet using the Google Sheets API
OpenAI NODES
Fetch OpenAI File
Generates a readable stream for a file stored in OpenAI Storage. Return this stream using a 'Return' node to receive it through an API endpoint (to download the file, write it to the file system, etc.)
script
Generate Embeddings
Generate embeddings for a given content using OpenAI text-embedding-ada-002 model
script
GPT-4 Vision
Use GPT-4 Vision to ask questions about images.
script
Image Generator
Converts text to Base64 image using OpenAI's DALL·E models.
script
JSON Generator
Generates text based on a given user and system prompt and always returns a JSON object using the OpenAI GPT (Turbo) APIs.
script
LLM Extract
Extract structured data from any text input.
script
LLM Extract URL
Extract structured data from any web page.
script
Multi-Image GPT-4 Vision
Analyses multiple images using the OpenAI GPT-4 Vision model.
script
Neighbor Search
Find the nearest neighbors for a given search query using OpenAI embeddings
script
OpenAI Assistant
Add different script nodes and let the AI Assistant automatically choose which to execute based on the input. Built to work with OpenAI Assistants API V2.
script
OpenAI Assistant (Stream Response)
Add different script nodes and let the AI Assistant automatically choose which to execute based on the input. The node returns a streamed text response (meant to be returned back to the client) and the thread ID (to track the conversation). Built to work with OpenAI Assistants API.
script
Stream Response
Send a chat message to OpenAI and return the response stream. --- If you plan on sending this stream back to the client as the response, you may want to consider adding a **Set Response Header** node following this node (and before the return node) with the key set to `content-type` and the value set to `text/plain`, to make it easier for the client to figure out how to handle the stream.
script
Text Generator
Generates text using OpenAI API for a given user and system prompt
script
Try it ->
Text to Speech
Converts text to speech using OpenAI API and returns audio in Base64.
script
Try it ->
Whisper Speech To Text
Convert audio/speech to text using OpenAI's Whisper API.
script
Try it ->
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.
