How to update file info for the Google Drive tool? Added new sheet to file on drive.

Question

I am trying to run a basic SQL query and output it to a file on my Google Drive.  I have the Google Drive tools configured in my Designer and was able to connect and find the file.  The file loaded in the sheet and tab information on the Configure File tab in designer.  On the drive itself I added a new tab into the sheet after making the connection.  On the Configure File tab in Designer I cannot make the new tab in the sheet show up.  I have tried pushing the Refresh File Browser on the Select File tab and also tried saving the workflow and opening Alteryx again but the new tab in the sheet is not showing up.  How can I get the Designer to show updated changes made to the file so I can route my SQL output to the new tab?

willisthiel074en · Accepted Answer

To see the new tab, you need to click the "Search" icon (magnifying glass) in the Google Drive Output tool to re-establish the connection and force Alteryx to pull the updated metadata from the live spreadsheet.

If the sheet still doesn't appear, you can manually type the new tab name into the "Sheet/Range" field in the tool’s configuration panel to force the write operation.