with Polygon and Google Appsheet?
Emit new events when a news article related to the stock market is published.
Emit new event when the daily price summary (open, high, low, close) for a specified stock ticker is available.
Emit new event when a trade occurs for a specified stock ticker.
Retrieves financial details for a specific company by stock ticker. See the documentation
Adds a new row to a specific table in the AppSheet app. See the documentation
Fetches historical price data for a specified stock ticker within a date range. See the documentation
Deletes a specific row from a table in the AppSheet app. See the documentation
Get the open, close and afterhours prices of a stock symbol on a certain date. See the documentation
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.
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}`,
},
})
},
})
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.
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,
})
},
})