Sheetgo Help Center

Features

A breakdown of every Sheetgo tool and how to use them

By Karoline and 2 others3 authors84 articles

Source features

Transfer formatting across spreadsheets

Use files from a folder as a source

Use the Offset Header setting

Use the Identify Data setting

Select tabs or a range from your spreadsheet

Data processors

Remove duplicates from a dataset

Merge_{4 articles}

Split_{4 articles}

Filter_{5 articles}

Left-Join_{1 article}

AI_{2 articles}

Destination features

Unlock and edit the destination tab

Use append to add rows below existing data

Use parse data setting

Automation triggers

What is the smart schedule and how to use it

What are automation triggers?

Set up smart scheduling for Workflows

Set up the Workflow Automation Trigger

Set up the Form Automation Trigger

Stop a run when there's an error

Document generation, PDF conversion and mail merge

What are smart tags?

Remove Sheetgo watermarks

Mail merge_{7 articles}

Document generation_{5 articles}

PDF conversion_{4 articles}

Sheetgo Forms

What is a Sheetgo Form?

How do Sheetgo Forms work?

Create a new Sheetgo Form

Configure your Sheetgo Forms

Configure subquestions for Sheetgo Forms

Organize your Sheetgo Forms

Edit a Sheetgo Form

Publish and customize a Sheetgo Form

Add custom validation to your Sheetgo Forms

Use formulas to enhance your Sheetgo Forms

Autofilling Sheetgo Forms through the URL

Dashboards

What is a Sheetgo Dashboard?

Create a Sheetgo Dashboard

Adding new information to a Dashboard

Editing a Dashboard

Share a Dashboard

Downloading individual charts from a Dashboard

Troubleshooting a Dashboard

Advanced data table features

How to create your Sheetgo dashboard

API

Connect an API to a spreadsheet

Set up refreshing tokens

Add pagination to get more data

Integrate Shopify with Google Sheets

Integrate Xero with Google Sheets

Integrate Quickbooks with Google Sheets

Integrate JIRA with Google Sheets

Integrations

Connect Shopify to Sheetgo

Fetch data from Shopify

BigQuery

Connect to BigQuery

Use BigQuery as a source

Use BigQuery as a destination

Create documents using BigQuery data

Get permissions for BigQuery

Turn a BigQuery table into a PDF