Relay.app Docs
  • Getting Started
    • Introduction
    • Helpful Resources
    • FAQ
  • Triggers
    • Triggers 101
    • Webhook Trigger
    • Mailhook Trigger
    • Manual Trigger
    • Scheduled Trigger
    • Batch Triggers
    • RSS Trigger
  • Actions in Apps
    • Actions 101
  • DATA
    • Step Outputs
    • Find Steps
    • Lists (Arrays)
    • Inspecting Run Data
  • AI
    • AI Steps
    • Human-in-the-Loop AI reviews
    • AI Credits
    • Agentic Tool Use
    • Knowledge
    • Prompt Templates
    • Prompt Tips
    • Audio Transcription
  • Built-in actions
    • Transform data
    • Search Google
    • Scrape Text from Website
    • Custom HTTP Requests
    • Run Custom Code (JS)
  • Flow Control
    • Paths
    • Iterators
    • Wait steps
    • Sequences
  • Human-in-the-Loop
    • Human-in-the-Loop Steps
    • AI output reviews
    • Roles
  • Workflows
    • Folders and Organization
    • Sharing Workflows
    • Headings
    • Notes
  • TEMPLATES
    • About Workflow Templates
    • Using a Template (Importing)
    • Creating a Template (Exporting)
  • Workspace
    • Step & AI credit usage
    • Billing and Plans
    • Workspace administration
    • (Sharing) App Accounts
  • App-Specific FAQs
    • Airtable
    • Attio
    • Cal.com
    • Coda
    • DeepSeek
    • Discord
    • Fireflies
    • Gmail
    • Google Docs
    • Google Drive
    • Google Sheets
    • Microsoft Permissions
    • Microsoft Outlook Mail
    • Notion
    • OpenAI
    • OpenPhone
    • Slack
    • X (Twitter)
    • QuickBooks Online
Powered by GitBook
On this page
  • How do I change the detected column type?
  • How does Relay.app infer column types in Google Sheets?
  • Updating infered column types

Was this helpful?

  1. App-Specific FAQs

Google Sheets

Last updated 2 months ago

Was this helpful?

How do I change the detected column type?

How does Relay.app infer column types in Google Sheets?

As Google Sheets doesn't have native types for columns, Relay.app infers the data type for each column based on the values in the first row (below the headers) of that column.

If the there is no row below the header row, Relay.app will assume a type based on the name of the header.

The depicted above is infered as follows in Relay.app:

Updating infered column types

To update the infered column types, add (or change) a/the value in the first row, and click the 'refresh' icon or 'Refresh data' from the overflow menu of a Step. After the column type has been re-inferred, you can remove data from the first row again if you just added it to force-infer the correct column type.

Relay.app infers data types for the columns based on the values in the first row
To force-refresh the column types as inferred by Relay.app, click the little 'refresh' icon
Generic way to refresh columns/data: click 'Refresh data' in the overflow menu of a Step