Google Sheets Tools (deprecated)

[#1]

The Google Sheets tools are deprecated. Install the Google Drive tools which provide updated features. 

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.

[marie_martin331]

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]

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

[pdamani]

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]

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. 

[mkosmicki1]

I just received the following error: "Warning: Google Sheets Input (68): There is no Question corresponding to the specified App/Macro value "version". The App/Macro may be out of date." 

I checked and it doesn't appear the macro has been updated.

Also, the Macro is requiring me to refresh my credentials every time I open the WF. I have 17 Google sheets and it takes 30 minutes each time I open the workflow to update every connector with credentials and tokens that haven't expired. I don't have this issue with my GA data connectors...only the G Sheets.

Is there something else I need to do for the oAuth and Token to persist?

-Michelle

[jbigler]

Hi Michelle,

I don't know if this might fix your issue, but I would suggest double-checking that you have the last version (3.0.0) of the Google Sheets Input tool.   I was having some issues which were resolved when I upgraded from 2.0.0 to 3.0.0.  You can right-click on the tool, and view the version number there.  

[mollynistler]

I've downloaded this tool numerous times. When the download finishes, I am still unable to choose Google Sheets as my file or database when I want to input data. Please advise!

[NikBarter]

I can see some files, but not all the files in our Google Drive - is there a permission problem perhaps - I've unlocked all the sheets and unhidden everything, but still not showing - is there any tips?

[wildflower]

Folks should be aware there is an acknowledged defect with Google Sheets v.3.0.0: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Google-Sheets-Connector-V3-0-401-Un...

[alexandriafrahm15]

Just here to share what I encountered trying to install Alteryx9Version 2022.1.1) with Google Sheets(deprecated version). It is a multi-step installation process:
1.) Install Alteryx Designer
2. Download Google Sheet Tools from Community: https://community.alteryx.com/t5/Community-Gallery/Google-Sheets-Tools-deprecated/ta-p/877888 
3.) Install tools (in your downloads, double click to open Designer and an "Install" pop up window will display)