Retrieve Teams access tokens and log them to Google Sheets. 获取Teams的访问令牌记录到 Google Sheets。
- Create a Google Sheet.
- Click Extensions > Apps Script in the menu bar.
- Copy the code from
code.gsinto the editor. - Click Deploy > New deployment, select Web app as the type, and set the access permission to Anyone.
- Copy the URL of the deployed web app.
- Download the repository code to your local machine.
- Open the Chrome browser and navigate to
chrome://extensions/. - Enable "Developer mode" in the top right corner.
- Click "Load unpacked" and select the project folder.
- Click the plugin and paste the deployed API link. Whenever a new browser window is opened, the access token will be automatically populated into Google Sheets.