Webhook logo
Polymarket logo
Google Sheets logo

Workflow template

Look up a Polymarket market and log it in Google Sheets

Read current Polymarket market details from a webhook market_id and append a six-field snapshot to Google Sheets. Use a public Polymarket connection with trading credentials left blank; this workflow reads data only.

How it works

From a Gamma market ID to a worksheet snapshot

1 Trigger · 2 Actions
Webhook1 · Trigger

Market lookup webhook

Receive market_id as a real numeric Gamma market ID. The included fictional ID must be replaced; protect the private webhook URL and configure source authentication as appropriate.

Polymarket2 · Action

Get market details

Read the requested Gamma market using a public connection. No trading credentials, funds or order action are needed; the following step uses the returned market metadata.

Google Sheets3 · Action

Append the market snapshot

Append market ID, question, outcomePrices, volume, liquidity and closed in A:F using RAW and INSERT_ROWS. Keep the source values rather than relabeling outcomes, converting prices or updating an existing row.

The result

A six-field snapshot of the requested market

Six source values in A:F of an existing worksheet. Add these labels manually if desired.
Market IDQuestionOutcome pricesVolumeLiquidityClosed
999999999999FICTIONAL: Will the workshop run on Friday?["0.60","0.40"]1200350false

Fictional market-data fixture, not live prices or a successful lookup of the sample ID. outcomePrices remains a source string, and false is the source closed flag. No outcome names or snapshot timestamp are mapped.

Before activation

Set up your workflow

  1. Create a public Polymarket connection

    Leave trading credentials blank. Choose a real numeric Gamma market ID rather than the fictional sample, a market slug, condition ID or outcome token ID.

  2. Choose the snapshot worksheet

    Connect Google Sheets and select an existing spreadsheet and worksheet. Reserve A:F for Market ID, Question, Outcome prices, Volume, Liquidity and Closed. Keep RAW and INSERT_ROWS, adding the labels manually if wanted.

  3. Protect the webhook and verify one lookup

    Configure source authentication as appropriate, activate and send a controlled market_id request. Compare the row with the returned Gamma market. Send again only when you intend another snapshot row.

Details and limitations
  • This reads metadata without trading. The workflow never places orders and needs no funds. It uses a public Polymarket connection rather than a trading account configuration.

  • Values remain as returned by Gamma. outcomePrices is copied without converting it to percentages or attaching outcome names. Volume and liquidity stay as source values, and closed stays a flag. No snapshot timestamp is included; RAW preserves formula-looking questions as text.

  • Every request appends a row. There is no upsert, continuous price feed or synchronization of earlier rows. Closed markets are not filtered by this mapping. Repeated requests and manual reruns can append duplicate snapshots.

Questions about this template

Do I need funds or trading credentials?

No. Use a public Polymarket connection and leave trading credentials blank. This workflow only reads Gamma market data and appends a worksheet row; it never places orders.

Which identifier should market_id contain?

Use a real numeric Gamma market ID. The sample 999999999999 is fictional and must be replaced; it is not a market slug, condition ID or outcome token ID.

Are prices labeled by outcome or converted to percentages?

No. outcomePrices is copied as the source value, without outcome names or percentage conversion. The other fields are market ID, question, volume, liquidity and closed; no snapshot timestamp is mapped.

Will a repeated request refresh the existing market row?

No. Each accepted request or manual rerun appends another RAW row. There is no upsert or automatic synchronization, and the prepared mapping does not filter closed markets.

Explore connected apps