This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.

Learn more
I AGREE
Reject
Welcome to the Gallery. Please feel free to post and comment, and check out our FAQ!
2022-05-26 Updates: Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.
community Data Science Portal Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Public Community Gallery

Post, download, and share all of your favorite tools and workflows — from Alteryx supported to user-built.
Welcome to the Gallery!

Feel free to migrate your items from the former Public Gallery or post new ones. Got questions? Check out our FAQ!

Google Sheets Tools Supported
Tools Uploaded by Moderator on 09/12/2021 Downloaded 1147 times
  • Data Connectors
  • Google
  • Tools
    • Download
    Post Comment

    Description

    Google Sheets Help Page

     

    Use the Google Sheets Input to download data from your Google Sheets spreadsheets and the Google Sheets Output to publish data to your Google Sheets spreadsheets.

     

    Current version

     

    Google Sheets v3.0.0 (September 3, 2021)

    • Compatible with Alteryx Designer version 2021.2 and later.

    • New and improved user interface.

    • Improved security of your instance when accessing the database and loading data into the workflow.

    Note: Due to improved security of your instance when accessing the database and loading data into the workflow, we recommend to use Google Sheets input and output tools v3.0.0.

     

    Previous versions

     

    Google Sheets v2.2.0 (March 26, 2020)

    • Fixed issue with the output tool where all data types are output as String.

    • Updated authentication for Designer 2020.2 and later versions.

    • For 2020.1 and earlier, authentication remains unchanged.

    • Added the ability to share a Connection Token across tools.

    • Compatible with Alteryx Designer version 2018.3 and later.

    Google Sheets v2.1.0 (February 27, 2020)

    • Compatible with Alteryx Designer version 2018.3 and later.

    • Mandatory update due to deprecation of Google Sheets API v3 (used in Google Sheets v2.0.0).

    • Updated Google Sheets API version from v3 to v4.

    • Output tool performance increased in comparison to tool version 2.0.0.

    Google Sheets v2.0.0 (Deprecated).

    • Mandatory update to Google Sheets v2.1.0.

    • Version 2.0.0 has been deprecated due to deprecation of Google Sheets API v3.

     

    This tool uses a .yxi file format. A .yxi file is a package that includes an Alteryx tool and all of its dependencies zipped into a single file. When this file is imported into Alteryx, the tool is added to the tool palette in the category specified by the tool.
    When sharing a workflow that uses a .yxi tool, the tool is not included and must be installed by the user.

    Attachments
    GoogleSheetsTools_v3.0.0.yxi
    Was this article helpful? Yes No
    Comments
    marie_martin331
    5 - Atom
    ‎01-25-2022 12:35 PM

    I've downloaded this tool and it doesn't show all the files that I have access to when I try to find it within "Google Sheet Input". Specifically, I'm looking for a google sheet that I have access to and it doesn't appear in the dropdown for Google. Could you assist me here?

     

    Thanks!

    Marie

    Blurryface619
    5 - Atom
    ‎04-13-2022 08:59 AM

    I'm seeing the files in my private folder but not the files in my shared folder. Is there a way to access them?

    0 Likes
    pdamani
    5 - Atom
    2 weeks ago

    I've installed the latest version of Designer. Every time I try to connect in order to configure the tool, Alteryx freezes and crashes. Does anyone else experience this or know what could be causing this?

    jbigler
    5 - Atom
    Wednesday

    Hi @pdamani.  After I upgraded to Alteryx Designer 2022.1 the Google Sheets Output tool stopped working for me.  Here is how I described it to Alteryx Support:

     

    When attempting to configure the Google Sheets Output tool, I am presented with the "Connect" button. When I click this, a medium-sized window pops up very briefly (I assume that this is an attempt to load the Google OAuth screen), but then immediately disappears.

     

    I have Case# 00546518 open with Support which they have acknowledged, but have not really done any analysis of yet. 

    0 Likes