How to Check for Updates in a Google Drive Folder?

Help
1

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

If I want to check to see if a Google Drive folder has been updated, what would I use?

2

To check if a Google Drive folder has been updated, you can use the Google Drive API to fetch the folder’s metadata and look for changes in the modifiedTime property. Here’s an example Pipedream component that makes a request to the Google Drive API to fetch folder metadata: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, folderId: { type: "string", label: "Folder ID", }, }, async run({ steps, $ }) { const url = `https://www.googleapis.com/drive/v3/files/${this.folderId}`; const response = await axios($, { url, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }, }); return response.modifiedTime; }, }); Replace folderId with the ID of the Google Drive folder you want to check. This component will return the modifiedTime of the folder, which you can compare with a previous value to determine if the folder has been updated.

3

I want to make a workflow where I can be alerted if a person uploads a file into a folder.

4

To create a workflow that alerts you when a file is uploaded to a Google Drive folder, you can use the Google Drive API to monitor the folder for changes. In this case, you can set up a Pipedream workflow with a Scheduler trigger to periodically check the folder for new files. Here’s an example Pipedream component that checks for new files in a Google Drive folder: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, folderId: { type: "string", label: "Folder ID", }, }, async run({ steps, $ }) { const url = `https://www.googleapis.com/drive/v3/files`; const response = await axios($, { url, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }, params: { q: `'${this.folderId}' in parents and mimeType != 'application/vnd.google-apps.folder' and trashed = false`, }, }); return response.data.files; }, }); Replace folderId with the ID of the Google Drive folder you want to monitor. This component will return the list of files in the folder. You can store the list of file IDs and compare it with the previous list to detect new files. If a new file is detected, you can send an alert using the desired notification method (e.g., email, Slack, etc.). Add this component to a new Pipedream workflow, and set up a Scheduler trigger to run the workflow at your desired interval (e.g., every 5 minutes). Then, add the necessary actions to send alerts when new files are detected.

5

how can I find a ROW in a spreadsheet by it’s value. Which app will do that?

6

To find a row in a Google Sheets spreadsheet by its value, you can use the Google Sheets API. You can create a Pipedream workflow with a Google Sheets component to search for the value in the spreadsheet. Here’s an example Pipedream component that searches for a specific value in a Google Sheets spreadsheet: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, spreadsheetId: { type: "string", label: "Spreadsheet ID", }, sheetName: { type: "string", label: "Sheet Name", }, searchValue: { type: "string", label: "Search Value", }, }, async run({ steps, $ }) { const url = `https://sheets.googleapis.com/v4/spreadsheets/${this.spreadsheetId}/values/${encodeURIComponent(this.sheetName)}!A1:Z1000`; const response = await axios($, { url, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }, }); const rows = response.data.values; let rowIndex = -1; for (let i = 0; i < rows.length; i++) { if (rows[i].includes(this.searchValue)) { rowIndex = i; break; } } if (rowIndex !== -1) { return { row: rows[rowIndex], rowIndex: rowIndex + 1 }; } else { return { message: "Value not found in the spreadsheet." }; } }, }); Replace spreadsheetId with the ID of the Google Sheets spreadsheet you want to search, and sheetName with the name of the sheet within the spreadsheet. This component will search for the searchValue in the specified sheet and return the row and row index if the value is found. If the value is not found, it will return a message indicating that the value was not found.

7

Earlier, you said to “Replace folderId with the ID of the Google Drive folder you want to monitor.” How do I do this if my folderID is called: steps[“get_record_or_create”][“$return_value”]? What would be the proper syntax?

8

To use the folder ID from a previous step in your Pipedream workflow, you can access it using the steps object. In your case, the folder ID is stored in steps.get_record_or_create.$return_value. You can modify the component code like this: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, folderIdFromPreviousStep: { type: "string", label: "Folder ID from Previous Step", }, }, async run({ steps, $ }) { const folderId = steps.get_record_or_create.$return_value; const url = `https://www.googleapis.com/drive/v3/files`; const response = await axios($, { url, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }, params: { q: `'${folderId}' in parents and mimeType != 'application/vnd.google-apps.folder' and trashed = false`, }, }); return response.data.files; }, }); In this example, I added a new prop folderIdFromPreviousStep to store the folder ID from the previous step. You can set the value of this prop in the Pipedream UI when configuring the component.

9

I’m getting a syntax error.

import { axios } from "@pipedream/platform";

export default defineComponent({
  props: {
    google: {
      type: "app",
      app: "google",
    },
    folderId: {
      type: "string",
      label: steps["get_record_or_create"]["$return_value"],
    },
  },
  async run({ steps, $ }) {
    const url = `https://www.googleapis.com/drive/v3/files`;
    const response = await axios($, {
      url,
      headers: {
        Authorization: `Bearer ${this.google.$auth.oauth_access_token}`,
      },
      params: {
        q: `'${this.folderId}' in parents and mimeType != 'application/vnd.google-apps.folder' and trashed = false`,
      },
    });

    return response.data.files;
  },
});
10

I apologize for the confusion. It seems there was a mistake in the provided code. The label property in the props object should be a human-readable string, not a reference to a previous step’s output. Instead, you should use a separate prop to store the folder ID from the previous step. Here’s the corrected code: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, folderIdFromPreviousStep: { type: "string", label: "Folder ID from Previous Step", }, }, async run({ steps, $ }) { const folderId = steps.get_record_or_create.$return_value; const url = `https://www.googleapis.com/drive/v3/files`; const response = await axios($, { url, headers: { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }, params: { q: `'${folderId}' in parents and mimeType != 'application/vnd.google-apps.folder' and trashed = false`, }, }); return response.data.files; }, }); In this example, I added a new prop folderIdFromPreviousStep to store the folder ID from the previous step. You can set the value of this prop in the Pipedream UI when configuring the component.

11

This is the error I am receiving.

Command failed: pipreqs --force ERROR: Failed on file: /tmp/__pdg__/dist/code/2b6811259b85645cabf0ae2e9d0adc40f25a6d7a7cda261f889fa4f354eb0cde/code.py Traceback (most recent call last): File "/var/lang/bin/pipreqs", line 8, in <module> sys.exit(main()) File "/var/lang/lib/python3.9/site-packages/pipreqs/pipreqs.py", line 528, in main init(args) File "/var/lang/lib/python3.9/site-packages/pipreqs/pipreqs.py", line 455, in init candidates = get_all_imports(input_path, File "/var/lang/lib/python3.9/site-packages/pipreqs/pipreqs.py", line 131, in get_all_imports raise exc File "/var/lang/lib/python3.9/site-packages/pipreqs/pipreqs.py", line 117, in get_all_imports tree = ast.parse(contents) File "/var/lang/lib/python3.9/ast.py", line 50, in parse return compile(source, filename, mode, flags, File "<unknown>", line 1 import { axios } from "@pipedream/platform"; ^ SyntaxError: invalid syntax
12

I apologize for the confusion. It seems the error you’re encountering is related to Python, but the code you provided is a Pipedream component written in JavaScript. Please make sure you’re using the correct environment to run your Pipedream component. Here’s the provided code again for reference: ```
import { axios } from “@pipedream/platform”; export default defineComponent({ props: { google: { type: “app”, app: “google”, }, folderId: { type: “string”, label: “Folder ID”, }, }, async run({ steps, $ }) { const url = https://www.googleapis.com/drive/v3/files; const response = await axios($, { url, headers: { Authorization: Bearer ${this.google.$auth.oauth_access_token}, }, params: { q: '${this.folderId}' in parents and mimeType != 'application/vnd.google-apps.folder' and trashed = false, }, }); return response.data.files; }, });