DEDUPED Hot AI repos, turned into use cases Get the Monday 5

How to connect the pipeline to a Google Sheet safely with Influencer Discovery

Mint a short-lived token by impersonating a service account so no key file sits on disk.

Credentials. The token call uses your ADC identity and a service account, so keep both out of shared logs and chat transcripts.

Who it is forA developer setting up shared outreach tracking who must avoid a long-lived service account key.

The problemGoogle blocks the spreadsheets scope on plain gcloud ADC, and storing a key file on disk is a risk.

The outcomeA working Sheets connection that appends rows using a token that expires after an hour.

What you need first

  • Python 3.11 or newer
  • A clone of the repo or a copy of skills/influencer-discovery/ into your agent's skills folder
  • Credentials for any channel that needs an API key or logged-in session (see the datalayer credentials section)
  • For Google Sheets output: a Google Cloud project with the sheets, iam, and iamcredentials APIs enabled, and a service account that can edit the target Sheet

Steps

  1. Set INFLUENCER_DISCOVERY_SPREADSHEET_ID in the config so the pipeline knows the target Sheet
  2. Enable the sheets, iam, and iamcredentials APIs in the Google Cloud project
  3. Grant your ADC identity roles/iam.serviceAccountTokenCreator on the service account and confirm the service account can edit the Sheet
  4. Run T=$(gcloud auth application-default print-access-token) and then the curl -s -X POST call to the iamcredentials generateAccessToken endpoint from the README, replacing YOUR_SA_EMAIL
  5. If the first call returns 403, wait about 30 seconds and retry, since IAM bindings take time to propagate

Prompt for your agent

Configure tigerless-labs/influencer-discovery to append to a Google Sheet using a short-lived token from the iamcredentials API for <service account email>. Verify that the header row matches the pipeline's mapping and that a test run appends one row without editing existing cells.

Caveat. The pipeline aborts if the Sheet header row does not match its mapping, so set up the header before the first run.

Share: X LinkedIn Hacker News Email Copy link

Disclaimer

Deduped lists open-source repositories that belong to other people. We do not own, maintain, audit, or vouch for any of them, and a repo appearing here is not an endorsement or a safety check. The use cases, steps, and prompts are written by AI and may be incomplete, outdated, or just wrong. Where a use case is marked "Seen in the wild", we link to public posts where someone described something similar, but we have not verified those posts and the use case itself is still our AI's own write-up. Use all of this at your own risk. Only run code, commands, or agents on systems and accounts you are authorized to use, and read the code and every command before you run it, especially anything that touches credentials, files, or the network. Nothing here is professional, security, legal, or financial advice. All trademarks and project names belong to their respective owners, and their use here does not imply affiliation. Content is provided as is, without warranties of any kind. Found a mistake, a safety problem, or something you want removed? Email [email protected] and we will look at it promptly. Full disclaimer page