Features
A breakdown of every Sheetgo tool and how to use them
By Jonatan and 2 others3 authors99 articles
- Automatic Table Creation and Schema Evolution for BigQueryLearn how to use new BigQuery destination features: automatic table creation, Replace writing strategy, schema evolution, and table partitioning.
- Webhook as a Source — v2.6.20bConnect external software directly to Sheetgo workflows to receive data the moment it is created, using a unique webhook URL.
- Faster syncs for Excel files in Google Drive and Dropbox
- Transfer formatting across spreadsheetsLearn how to transfer text formatting, number styles, borders, cell color, and more
- Use files from a folder as a sourceUnderstand how you can have all the files in a folder as a source for your workflow
- Use the Offset Header settingTell Sheetgo where your column labels are when they're not on row 1, or specify that your file has no header row at all.
- Use the Identify Data settingLearn how to get data traceability and see which source file your destination sheet data originated from
- Select tabs or a range from your spreadsheetControl exactly what data is drawn from the data source
- Unlock and edit the destination tabLearn how to edit data in the destination tab, apply formulas, and keep extra columns after updates.
- Use append to add rows below existing dataAppend data to the destination. Ideal for creating data logs and historical reports.
- Use parse data settingLearn how to parse data setting when transferring numerical values
Automation triggers
Set up different automation triggers
- What is the smart schedule and how to use itLearn about smart schedules and use them to keep your spreadsheets updated.
- What are automation triggers?Learn what automation triggers are and how they work.
- Set up smart scheduling for WorkflowsSet up an hourly, daily, weekly, and monthly schedule to automate your automations.
- Set up the Workflow Automation TriggerEnable and configure the workflow automation trigger
- Set up the Form Automation TriggerEnable and configure the Form automation trigger
- Stop a run when there's an errorConfigure your workflow's execution settings
- How to set up your workflow to run automaticallyLearn what are the triggers and how to use it to keep your spreadsheets updated even when you are offline
- What is a Sheetgo Form?Learn what a Sheetgo Form is and understand the logic behind it.
- Form Submissions with ApprovalRequire manual approval before form submissions reach your spreadsheet. Review, approve, or reject responses by email or from within the app.
- How do Sheetgo Forms work?Learn what a Sheetgo form is and references for creating, editing, and adding one to your workflow
- Create a new Sheetgo FormLearn how to create a Sheetgo Form and add it to your workflow
- Configure your Sheetgo FormsLearn what a Sheetgo form configuration is and how to use them
- Configure subquestions for Sheetgo FormsDependent follow-up questions whose options adapt based on the answer to the main question.
- Organize your Sheetgo FormsLearn different configurations to optimize your forms layouts
- Edit a Sheetgo FormLearn how to edit and sync an existing form
- Publish and customize a Sheetgo FormLearn how to generate a link to easily share your forms and edit its appearance
- Add custom validation to your Sheetgo FormsLearn to use regular expression (regex) in your forms
- Use formulas to enhance your Sheetgo FormsLearn how you can combine Sheetgo forms configuration with spreadsheet formulas
- Autofilling Sheetgo Forms through the URLAutocomplete fields by passing values in the URL
Dashboards
Use the Sheetgo dashboard feature
- What is a Sheetgo Dashboard?Learn the benefits of using Sheetgo to showcase data from your workflows
- Create a Sheetgo DashboardVisualize and share data from your Google Sheets
- Adding new information to a DashboardAdd charts, tables and indicators to a Dashboard
- Editing a DashboardLearn how to label and arrange items in a Dashboard
- Share a DashboardShare a dashboard on the web, in an email or download it as a PDF
- Downloading individual charts from a DashboardLearn how you can save graphs from your dashboard on your computer
- Troubleshooting a DashboardCommon errors and how to fix them
- Advanced data table featuresEnhance data tables with filters, sorting, and interactive elements
- How to create your Sheetgo dashboardGet started with the dashboard feature
API
Connect an API to your Sheetgo Workflow
- Use an API endpoint as a DestinationExpose workflow automation results at a private, on-demand API endpoint that external systems can read.
- Use Webhook as a DestinationPush workflow automation results automatically to any external HTTP endpoint.
- Clean and format REST API data with the AI ProcessorAutomatically clean and normalize API data before it reaches your spreadsheet — no formulas or post-processing needed.
- Use dynamic placeholders in API connectionsKeep API connections up to date automatically using live values from your spreadsheet.
- A1 Notation in API Source — Basic GuideUse cell references ({{TabName!CellRef}}) in your API Source URL, headers, or body to pull live values from your destination Google Sheet at run time.
- A1 Notation in API Source — Advanced GuideFull reference for the {{...}} placeholder syntax in API Source: render modes, string, numeric, and date filters, with complete examples and error-handling behaviour.
- Connect an API to a spreadsheetLearn how you can use an API link as a source on a workflow
- Set up refreshing tokensAuthorize API requests with Oauth2
- Add pagination to get more dataFetch more than one page of data from an API
- Connect Shopify via API / HTTP Request (advanced)Connect your Shopify account directly to Google Sheets
- Integrate Xero with Google SheetsConnect Xero to Sheetgo and automatically sync accounting data to Google Sheets using the Xero API.
- Integrate Quickbooks with Google Sheets
- Integrate JIRA with Google SheetsAutomate your project tracking
- Use Webhook as a sourceLearn how to set up a Webhook as a source in Sheetgo to receive data from external apps and services via HTTP POST request.
- Using the AI data processorAdd AI processing to your Sheetgo automations using OpenAI. Learn how to write effective prompts and get the best results from your data.
- Connect Shopify to SheetgoConfigure Shopify store to include their data in your workflows.
- Fetch data from ShopifyLearn how to leverage store data in your workflows
- Setting up your own OpenAI accountConnect your paid OpenAI account to Sheetgo to use custom AI models, configure advanced settings, and deploy your GPTs in automations.
BigQuery
Connect BigQuery to your Sheetgo automations
- Connect to BigQueryLearn about the necessary permissions to import data from a BigQuery table
- Use BigQuery as a sourceBring data from your BigQuery database to a workflow
- Use BigQuery as a destinationLearn how to transfer data to a BigQuery table
- Create documents using BigQuery dataAutomatically generate documents and PDFs with data from a BigQuery table using Sheetgo
- Get permissions for BigQueryEverything you need to use BigQuery as a source or as a destination