What do you want to automate

with Polygon and Google Appsheet?

Prompt, edit and deploy AI agents that connect to Polygon, Google Appsheet and 2,500+ other apps in seconds.

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Add Row with Google Appsheet API on New Market News from Polygon API
Polygon + Google Appsheet
 
Try it
Add Row with Google Appsheet API on New Stock Price Summary from Polygon API
Polygon + Google Appsheet
 
Try it
Add Row with Google Appsheet API on New Stock Trade from Polygon API
Polygon + Google Appsheet
 
Try it
Delete Row with Google Appsheet API on New Market News from Polygon API
Polygon + Google Appsheet
 
Try it
Delete Row with Google Appsheet API on New Stock Price Summary from Polygon API
Polygon + Google Appsheet
 
Try it
New Market News from the Polygon API

Emit new events when a news article related to the stock market is published.

 
Try it
New Stock Price Summary from the Polygon API

Emit new event when the daily price summary (open, high, low, close) for a specified stock ticker is available.

 
Try it
New Stock Trade from the Polygon API

Emit new event when a trade occurs for a specified stock ticker.

 
Try it
Get Company Financials with the Polygon API

Retrieves financial details for a specific company by stock ticker. See the documentation

 
Try it
Add Row with the Google Appsheet API

Adds a new row to a specific table in the AppSheet app. See the documentation

 
Try it
Get Historical Prices with the Polygon API

Fetches historical price data for a specified stock ticker within a date range. See the documentation

 
Try it
Delete Row with the Google Appsheet API

Deletes a specific row from a table in the AppSheet app. See the documentation

 
Try it
Get Stock Price with the Polygon API

Get the open, close and afterhours prices of a stock symbol on a certain date. See the documentation

 
Try it
Integrate the Polygon API with the Google Appsheet API
Setup the Polygon API trigger to run a workflow which integrates with the Google Appsheet API. Pipedream's integration platform allows you to integrate Polygon and Google Appsheet remarkably fast. Free for developers.

Overview of Polygon

The Polygon API grants access to a wealth of financial data, including real-time and historical stock prices, trade data, and more. Within Pipedream's serverless integration platform, you can tap into Polygon to create powerful workflows. With Pipedream, you can easily connect Polygon to hundreds of other apps, automate financial data processing, send stock alerts, or synchronize market data with databases or spreadsheets, all in real-time.

Connect Polygon

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    polygon: {
      type: "app",
      app: "polygon",
    }
  },
  async run({steps, $}) {
    return await axios($, {
      url: `https://api.polygon.io/v2/aggs/ticker/AAPL/range/1/day/2020-06-01/2020-06-17`,
      params: {
        apiKey: `${this.polygon.$auth.api_key}`,
      },
    })
  },
})

Overview of Google Appsheet

The Google Appsheet API enables programmatic interactions with your custom AppSheet applications, allowing you to streamline processes, automate actions, and interlink your apps with other services. Leveraging Pipedream's powerful serverless platform, you can create workflows that react to events in real-time, automate tasks, and connect to countless other services with minimal effort. Whether you're updating datasets, syncing with external systems, or triggering complex chains of actions, combining AppSheet with Pipedream can supercharge your productivity and enhance your app's capabilities.

Connect Google Appsheet

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
import { axios } from "@pipedream/platform"
export default defineComponent({
  props: {
    google_appsheet: {
      type: "app",
      app: "google_appsheet",
    }
  },
  async run({steps, $}) {
    const data = {
      "Action": "Find",
      "Properties": `{
          "Locale": "en-US",
          "Selector": "Filter(Sheet1, true)",
          "Timezone":
          "Pacific Standard Time"
      }`,
    }
    return await axios($, {
      method: "post",
      url: `https://api.appsheet.com/api/v2/apps/${this.google_appsheet.$auth.app_id}/tables/{{your_table_here}}/Action`,
      headers: {
        "ApplicationAccessKey": `${this.google_appsheet.$auth.access_key}`,
      },
      data,
    })
  },
})

Trusted by 1,000,000+ developers from startups to Fortune 500 companies

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo