CustomGPT + Google Sheets

Create Google Sheets rows for each new conversation in CustomGPT

Effortlessly manage and archive your new CustomGPT app conversations by instantly creating a row in Google Sheets. This workflow empowers you to smoothly transform online interactions into data without manual entry, enhancing productivity and ensuring you never lose important details from your conversations. Enjoy an organized and efficient system for your business communication that keeps all your critical information securely stored and easily accessible.

When this happens...
New Conversation
Trigger when a new conversation is added.
TriggerInstant
automatically do this!
Create Spreadsheet Row
Create a new row in a specific spreadsheet.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Supported triggers and actions

- Project NameRequired
Trigger
Instant
Try It
- Project NameRequired
- Conversation NameRequired
Action
Write
- Project NameRequired
Action
Write
- Choose NameRequired
- Project Name
- Project is shared
Action
Write
- Project NameRequired
- Data RetentionRequired
- Filename For Storing FileRequired
- File For Processing Required
Action
Write

- Project NameRequired
Action
Search
- Project NameRequired
Action
Search or write

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
Trigger
Polling
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Use Timezone set up on the spreadsheet to format date values?
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup columnRequired
- Lookup valueRequired
- Supporting lookup column
- Supporting lookup value
- Search from last row
- Row count
Action
Search or write

- Project NameRequired
- Conversation Name
Trigger
Instant
Try It
- Project NameRequired
Action
Write
- Project NameRequired
- Conversation NameRequired
- LangRequired
- Message TextRequired
- External ID
Action
Write
- Project NameRequired
- The chat bot avatar
- The background image for widget
- Default prompt
- Questions shown to guide the bot users
- Response source
- Chat bot message language
- Color of the chatbot in hex format
- Persona instructions
- Label for citations
- Label for sources
- Waiting answer message
- "Siesta" message
- Show animated loading indicator
- Show citations
- How citations are shown
- "No answer" message
- Ending message
- Remove branding
- Chat bot GPT model
- Allow conversation sharing
- Allow conversation export
- Allow agent to mention sources
Action
Write
- Project NameRequired
- Conversation NameRequired
Action
Search
- Project NameRequired
- Conversation NameRequired
Action
Search or write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Polling
Try It
- Drive
Trigger
Polling
Try It
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Write
- Info
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Row(s)Required
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Bold
- Italic
- Strikethrough
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row countRequired
- Output format
- First row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Overwrite existing worksheet with the same title
- Headers
Action
Search or write

About CustomGPT

CustomGPT builds your own AI-powered chatbot with your business content. Easy, no-code platform used by total beginners as well as advanced developers.

Learn more

Related categories

AI Tools

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

CustomGPT + Google Sheets

Create Google Sheets rows for each new conversation in CustomGPT

New Conversation

Create Conversation

Delete Project

Update Project

Upload File

Find Project

Find or Create Project

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Create Spreadsheet Row at Top

Create Spreadsheet

Clear Spreadsheet Row(s)

Format Spreadsheet Row

Update Spreadsheet Row(s)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

New Message

Create Project

Send Message

Update Settings

Find Conversation

Find or Create Conversation

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Copy Worksheet

Create Worksheet

Delete Spreadsheet Row(s)

Update Spreadsheet Row

API Request (Beta)

Get Many Spreadsheet Rows (Advanced)

Find or Create Worksheet

About CustomGPT

Related categories

About Google Sheets

Related categories

Similar apps

Zapier Tables

Zoho Creator

Smartsheet

Related Zap Templates

Related Zap Templates