Why is Google Sheet Not Loading My Data?

Bugs
1

This topic was automatically generated from Slack. You can find the original thread here.

@channel I am still trying to load stuffs from google sheet and its still not doing it

2

Hi , you can try to ask our bot @U05A7KLNALC for questions related to how to use Pipedream

3

i know how to use it

4

I’m here to help you with your Google Sheets issue. To load data from Google Sheets, you can use the Google Sheets API. First, you’ll need to connect your Google account to Pipedream. Here’s an example Pipedream component that reads data from a Google Sheet: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, spreadsheetId: { type: "string", label: "Spreadsheet ID", }, range: { type: "string", label: "Range", description: "Enter the range of cells to read, e.g. 'Sheet1!A1:D5'", }, }, async run({ steps, $ }) { const sheetsUrl = `https://sheets.googleapis.com/v4/spreadsheets/${this.spreadsheetId}/values/${this.range}`; const response = await axios($, { url: sheetsUrl, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }, }); return response; }, }); Replace spreadsheetId and range with the appropriate values for your Google Sheet. This component will return the data from the specified range in the sheet. If you need further assistance, please let me know!

5

the issue is its not pulling the info from the sheet