How to retrieve & replace Google Sheet input tool connection token information?

[Kevincoco]

Hi the Alteryx Community,

I would like to know:
1- How can I retrieve the connection token of one of my Google Sheet Inputs tool (Master Connection Token Workflow Alteryx file cf. screenshot 1)?

2- And use it to replace the connection token of other Google Sheet Inputs tool in other Alteryx files (Customer Workflow & Product Workflow cf. screenshots 2 & 3)?

Screenshot 1: Master Connection Token Workflow

Master Connection Token Workflow

Screenshot 2: Customer Workflow

Customer Workflow

Screenshot 3: Product Workflow

Product Workflow

Looking forward your help and feedback 🙂

Best,

Kevin

[TrevorS]

Hello @Kevincoco 

Please take a look at the Help doc for the Google Sheets Input Tool.
This should help you to move forward with the changes you are looking to make!
Thanks,
TrevorS

[Kevincoco · Accepted solution]

Thanks TrevorS,

I actually figure out a solution with the help of Alteryx experts (alteryx virtual solution center) which is to:
1- use one input google sheet tool to authenticate and generate a connection token

2- save this token in a csv

3- use a macro to populate this connection token to all other google sheet input tools

It works!

Best,

Kevin