[GSC-PUBLIC-1] fetch data
•@apurvgpt•
•code:
•data:private•last updated:3 years ago
today
Build integrations remarkably fast!
You're viewing a public workflow template.
Sign up to customize, add steps, modify code and more.
Join 1,000,000+ developers using the Pipedream platform
steps.
trigger
HTTP API
Deploy to generate unique URL
This workflow runs on Pipedream's servers and is triggered by HTTP / Webhook requests.
steps.
get_values
auth
to use OAuth tokens and API keys in code via the
auths object(auths.google_sheets)
params
SpreadhsheetId
The ID of the spreadsheet to insert rows into. The spreadsheetID can be found in the URL when viewing your Google sheet. E.g., https://docs.google.com/spreadsheets/d/[spreadsheetId]/edit#gid=0
string ·params.spreadhsheetId
Range
The A1 notation of the values to retrieve. E.g., A1:E5 or Sheet1!A1:E5
string ·params.range
code
Write any Node.jscodeand use anynpm package. You can alsoexport datafor use in later steps via
return or this.key = 'value', pass input data to your code viaparams, and maintain state across executions with$checkpoint.async (event, steps, params, auths) => {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
30
}31
const { google } = require('googleapis')
const axios = require('axios');
const delay = ms => new Promise(resolve => setTimeout(resolve, ms));
const auth = new google.auth.OAuth2()
auth.setCredentials({ access_token: auths.google_sheets.oauth_access_token })
const sheets = await google.sheets({ version: 'v4', auth });
const response = await sheets.spreadsheets.values.get({
spreadsheetId: params.spreadhsheetId,
range: params.range
})
const urlData = response.data.values;
for (const [currentIndex, currentUrl] of urlData.entries()) {
const config = {
url: '<<webhook url to next workflow>>',
method: 'POST',
data: {
currentUrl: currentUrl[0],
currentIndex
}
}
await delay(2500);
const response2 = axios(config);
console.log(response2.data);
}