LogoLogo
ProductsPricingGlossary Launch Acho
  • 🎉Welcome
  • Introduction
  • What is Acho?
  • How does Acho work?
    • Proof of Concept (PoC)
  • App Builder
    • Get Started
    • Core Concepts
    • Overview
    • App construction
      • App Configuration
      • Pages
      • Interactions
        • Add an interaction
        • Add conditions to interactions
        • Event payload
        • Ordering interactions with action flow
        • Transformer
        • Actions
          • Navigation
          • Element
          • Data Source
          • App
          • Page
          • API Service
          • Database
          • Media Service
      • Table
      • Metric
      • Query
      • Data Store
      • Elements
        • Table & Chart
          • Searchable Table
          • Table
          • Chart
          • Score Card
        • Form Elements
          • Form
          • Search Bar
          • Checkbox
          • Date Picker
          • Custom Form
          • Input
          • Multiselect
          • Radio Button
          • Radio List
          • Rich Text Editor
          • Select
          • Switch
          • Textarea
          • Upload
        • Web Elements
          • Badge
          • Button
          • Clickable
          • Collapse Menu
          • Divider
          • Icon
          • Image
          • Link
          • Message
          • Modal
          • Notification
          • Pagination
          • Popover
          • Rate
          • Rich Text
          • Tabs
          • Text
        • Layout Elements
          • Container
          • List
        • Advanced elements
          • Code Block
          • Condition
          • Print
        • CSS Styles
          • General techniques
          • Layout
          • Spacing
          • Size
          • Position
          • Typography
          • Background
          • Border
          • Effect
        • Form Check
        • Tooltip
      • Accessors
      • Plugin Store
    • Popular Use Cases
      • Build a chart from Table Nodes
      • Create a table
      • Create a list
      • Create a filter
      • Create a search bar
      • Use Custom Form Container to collect user inputs
      • Drill down on a table
      • Download file from query node
      • Set loading animations
      • Modify a database
      • Navigate to a different page
      • Set up dynamic routing
      • Update app data using accessors
      • Create a Chart with Code Block and D3 Library
      • Rich text and rich text editor
      • Send an Email via Mailjet Plugin
    • Preview
    • Publish
      • Embed published app on website
    • Version Control
    • App User Management
      • Onboarding Page
      • Sign in page
      • Guest Isolation and Private Session
    • Theme
    • FAQ
  • Acho Studio
    • Quick Start
    • Resources
      • Add a resource
      • Supported data sources
        • Airtable
        • Amazon Ads
        • Amplitude
        • Amazon Seller Partner
        • Apify Dataset
        • Appstore
        • Asana
        • API Connector
        • API Template
        • AWS CloudTrail
        • Azure Table Storage
        • Batch Files
        • Bamboo HR
        • BigCommerce
        • BigQuery
        • Bing Ads
        • Braintree
        • Cart.com
        • Chargebee
        • Chargify
        • Chartmogul
        • Clickhouse
        • Close.com
        • CockroachDB
        • Confluence
        • Customer.io
        • Delighted
        • Dixa
        • Drift
        • Facebook Marketing
        • Freshdesk
        • Freshsales
        • Freshservice
        • GitHub
        • GitLab
        • Google Ads
        • Google Analytics
        • Google Sheets
        • Google Search Console
        • Greenhouse
        • Harness
        • Harvest
        • HubSpot
        • IBM Db2
        • Instagram
        • Intercom
        • Iterable
        • Jenkins
        • Jira
        • Kafka
        • Klaviyo
        • Kustomer
        • Lemlist
        • Lever Hiring
        • LinkedIn Ads
        • Linnworks
        • Mailchimp
        • Marketo
        • Microsoft Teams
        • Mixpanel
        • Monday
        • MongoDB
        • MySQL
        • My Hours
        • NetSuite
        • Notion
        • Okta
        • OneDrive
        • OneSignal
        • Oracle DB
        • Outreach
        • PagerDuty
        • Paypal Transaction
        • Paystack
        • Pipedrive
        • PersistIq
        • Pinterest
        • Plaid
        • PostgreSQL
        • PostHog
        • PrestaShop
        • Qualaroo
        • QuickBooks
        • Recharge
        • Recurly
        • Remote File
        • S3
        • Salesforce
        • Salesloft
        • SearchMetrics
        • Sendgrid
        • Sentry
        • Short.io
        • Shopify
        • Single File
        • Slack
        • Smartsheets
        • Snapchat Marketing
        • Snowflake
        • SQL Server
        • Square
        • Stripe
        • SurveyMonkey
        • Tempo
        • TikTok Marketing
        • Trello
        • Twilio
        • Typeform
        • VictorOps
        • WooCommerce
        • YouTube Analytics
        • Zendesk Chat
        • Zendesk Sunshine
        • Zendesk Talk
        • Zendesk Support
        • Zenloop
        • Zoho CRM
        • Zoom
        • Zuora
    • Data Prep (Projects)
      • Create a Data Prep Project
        • Create a table tab
        • Copy a table tab
        • Hide a table tab
      • Apply an action
        • View
          • Hide Columns
          • Filter
          • Sort
          • Cut
          • Rename
          • Move Column
        • Combine Tables
          • Join
          • Union
        • Transformation
          • Pivot Table
          • Unpivot
        • Data Cleaning
          • Cleanse
          • Replace
          • Change Type
          • Deduplicate
          • Split
          • Flatten
        • Tools
          • Formula
          • SQL Editor
            • SQL Editor Queries
            • All functions in Formula/SQL
              • Mathematical Functions
              • String Functions
              • Date Functions
              • Datetime Functions
              • Time Functions
              • Timestamp Functions
              • Conditional Functions
              • Type Conversion
              • Other Functions
        • Reserved Keywords
      • Pipeline
      • Edit your pipelines
      • Generate column summary for inspection
      • Use URL to access and share your project
      • Write a description for your project
      • Delete a resources/project/tab
    • Data Flow
      • Export data
        • Download CSV files
        • Excel Connector
        • Google Sheets Connector
        • Embed a table on your website
          • Data Usage Agreement
        • Apache Superset
        • Chartio
        • Looker
        • Metabase
        • Power BI
        • Qlik
        • Tableau
        • MongoDB
        • MySQL
        • MSSQL
        • Snowflake
        • PostgreSQL
        • BigQuery
    • Set up Data Sync
    • FAQ
  • Organization
    • Get started
    • Create an organization
    • Invite people to your organization
    • Share your resources
    • Share your projects
    • Share your apps
    • Change payment method on file
  • FAQ
    • I can't find data after uploading a big CSV file
Powered by GitBook
On this page
  • 1. How to import data from Google Sheets?
  • 2. How to find the Spreadsheet ID?
  • 3. How to set up Data Sync?
  • 4. Troubleshooting
  • Issue 1: Fail to connect Google Sheets
  • Issue 2: Missing columns

Was this helpful?

  1. Acho Studio
  2. Resources
  3. Supported data sources

Google Sheets

PreviousGoogle AnalyticsNextGoogle Search Console

Last updated 2 years ago

Was this helpful?

1. How to import data from Google Sheets?

You can follow the following steps to import datasets from your Google Sheets. Each connection is allowed to import only one google sheet file. If there are several worksheets in your file, each worksheet becomes a separate table. For example, if your google sheet file has 4 worksheets, they will be displayed in 4 tables on Acho.

1. Go to the Resources page and click the Add Resource button.

2. In the "Select a data source" step, select Google Sheets under the Application tab.

3. In the "Configure the data source" step, Acho offers two methods to connect your Google Sheets:

  • Method 1: Log in to your Google Account and select one of your Google Sheets

  • Method 2: Connect to your Google Sheets manually. First, open your google sheet and share your spreadsheet to Acho's address: acho-integration-google-acc@tool-for-analyst.iam.gserviceaccount.com Then, enter your Spreadsheet ID on Acho (Find your spreadsheet ID ) .

2. How to find the Spreadsheet ID?

1. Open your Google Sheet.

2. Share your file to Acho's address and set the role as Viewer: acho-integration-google-acc@tool-for-analyst.iam.gserviceaccount.com

Click the Share button again to make sure Acho's address exists in your list.

3. Click the address bar and copy the spreadsheet ID between /d/ and /edit# in the URL. (See the following graph)

3. How to set up Data Sync?

4. Troubleshooting

Issue 1: Fail to connect Google Sheets

Please check the following points:

  1. Make sure that you've already shared your spreadsheet to Acho's address in Google Sheet: acho-integration-google-acc@tool-for-analyst.iam.gserviceaccount.com

  2. Check if there is an empty sheet in your google sheet. If some of the worksheets have no data, please delete them. For example, Sheet1 in the following example is empty. You should remove it to avoid the failure of the connection.

4. The first row in any worksheets cannot be empty. Acho considers the first row as a header, and thus the system occurs errors if the first row is empty.

Issue 2: Missing columns

If your google sheet is supposed to have 5 columns, but it only displays 3 columns on Acho.

Please check if any column name is empty. Empty columns name may make Google's API unable to parse the file correctly, and thus some columns may be missing when importing data to Acho. Here are some examples that are possible to cause this issue:

  • One of the columns has an empty column name. By adding the column name, the problem can be solved.

  • One of the columns is empty. By deleting the empty columns, the issue can be solved.

4. Click Finish Setup. You will see a icon next to your Google Sheets resource. It may take a few minutes to several hours to retrieve data depending on the data size and the number of your tables. Once your APP's data is ready, you will receive a notification email.

Acho supports creating schedulers to retrieve the latest data from your Google Sheet at a certain time interval. To see more details, you can visit .

Check if there are any missing or unnecessary values in your . You can find the ID in the spreadsheet's URL, which is located between /d/ and /edit# .

here
spreadsheet ID
here