How to Rename a Google Doc Using Google Drive?

Help
1

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

How can I rename a Google Doc using the Google Drive?

2

To rename a Google Doc using the Google Drive API, you can use the following Pipedream component code: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, fileId: { type: "string", label: "File ID", }, newTitle: { type: "string", label: "New Title", }, }, async run({ steps, $ }) { const url = `https://www.googleapis.com/drive/v3/files/${this.fileId}`; const headers = { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, "Content-Type": "application/json", }; const data = { name: this.newTitle, }; return await axios($, { method: "PATCH", url, headers, data, }); }, }); Replace fileId with the ID of the Google Doc you want to rename, and newTitle with the new title you want to set for the document. This code uses the Google Drive API to update the document’s name.

3

is there a date app?

4

I’m not sure what you mean by a “date app.” Could you please provide more information or clarify your question? This will help me understand your requirements and provide a better answer.

5

a way to get today’s date and insert it into a string.

6

To get today’s date and insert it into a string, you can use the following code snippet in a Pipedream component: ```
export default defineComponent({ async run({ steps, $ }) { const today = new Date(); const formattedDate = ${today.getFullYear()}-${today.getMonth() + 1}-${today.getDate()}; return formattedDate; }, });

7

I’d like the date to start with zeros. Like 2023-08-01.

8

To get today’s date with leading zeros and format it as “YYYY-MM-DD”, you can use the following code snippet in a Pipedream component: ```
export default defineComponent({ async run({ steps, $ }) { const today = new Date(); const formattedDate = ${today.getFullYear()}-${String(today.getMonth() + 1).padStart(2, '0')}-${String(today.getDate()).padStart(2, '0')}; return formattedDate; }, });

9

I ran this code:

export default defineComponent({
  async run({ steps, $ }) {
    const today = new Date();
    const formattedDate = `${today.getFullYear()}-${String(today.getMonth() + 1).padStart(2, '0')}-${String(today.getDate()).padStart(2, '0')}`;
    return formattedDate;
  },
});

And I was given this error:

Error - Request failed with status code 404
{"error":{"code":404,"message":"File not found: 162ayIt09nGzHhW3ILgdpiK5jNl-bFVP1phO475fBsfQ.","errors":[{"message":"File not found: 162ayIt09nGzHhW3ILgdpiK5jNl-bFVP1phO475fBsfQ.","domain":"global","reason":"notFound","location":"fileId","locationType":"parameter"}]}}
10

It seems like the error you encountered is unrelated to the date formatting code you provided. The error message indicates that a file with the specified ID was not found in Google Drive. It’s likely that the error is coming from another part of your workflow that involves Google Drive. Please double-check your workflow to ensure you’re using the correct file ID and that the file exists in your Google Drive. If you still face issues, please provide more information about your workflow, and I’ll be happy to help.

11

You are correct. I gave you the wrong code.

The code I used is:

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

export default defineComponent({
  props: {
    google: {
      type: "app",
      app: "google",
    },
    fileId: {
      type: "string",
      label: "File ID",
    },
    newTitle: {
      type: "string",
      label: "New Title",
    },
  },
  async run({ steps, $ }) {
    const url = `https://www.googleapis.com/drive/v3/files/${this.fileId}`;
    const headers = {
      Authorization: `Bearer ${this.google.$auth.oauth_access_token}`,
      "Content-Type": "application/json",
    };
    const data = {
      name: this.newTitle,
    };

    return await axios($, {
      method: "PATCH",
      url,
      headers,
      data,
    });
  },
});

and the error I encountered was:

Error - Request failed with status code 404
{"error":{"code":404,"message":"File not found: 162ayIt09nGzHhW3ILgdpiK5jNl-bFVP1phO475fBsfQ.","errors":[{"message":"File not found: 162ayIt09nGzHhW3ILgdpiK5jNl-bFVP1phO475fBsfQ.","domain":"global","reason":"notFound","location":"fileId","locationType":"parameter"}]}}
12

It seems like the error you encountered is related to an incorrect URL format in your code. The angle brackets < and > around the URL are causing the issue. Please remove them and try again. Here’s the updated code: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, fileId: { type: "string", label: "File ID", }, newTitle: { type: "string", label: "New Title", }, }, async run({ steps, $ }) { const url = `https://www.googleapis.com/drive/v3/files/${this.fileId}`; const headers = { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, "Content-Type": "application/json", }; const data = { name: this.newTitle, }; return await axios($, { method: "PATCH", url, headers, data, }); }, }); This should resolve the error. Make sure you’re using a valid Google Drive file ID in the fileId prop. If you still face issues, please provide more information about your workflow, and I’ll be happy to help.

13

Finally, how can I trim a string down to 64 characters?

14

To trim a string down to 64 characters in a Pipedream component, you can use the slice() method within the run method. Here’s an example: export default defineComponent({ props: { inputString: { type: "string", label: "Input String", }, }, async run({ steps, $ }) { const trimmedString = this.inputString.slice(0, 64); return trimmedString; }, }); In this example, the inputString prop takes the string you want to trim. The slice() method trims the string to the first 64 characters.

15

I’m on EST time.

This date code is not. Can you fix it for me?

export default defineComponent({
  async run({ steps, $ }) {
    const today = new Date();
    const formattedDate = `${today.getFullYear()}-${String(today.getMonth() + 1).padStart(2, '0')}-${String(today.getDate()).padStart(2, '0')}`;
    return formattedDate;
  },
});
16

To adjust the date code for EST timezone, you can use the Intl.DateTimeFormat object with the timeZone option set to “America/New_York”. Here’s the updated code: export default defineComponent({ async run({ steps, $ }) { const today = new Date(); const estDate = new Intl.DateTimeFormat("en-US", { timeZone: "America/New_York", year: "numeric", month: "2-digit", day: "2-digit", }).format(today); const [month, day, year] = estDate.split("/"); const formattedDate = `${year}-${month}-${day}`; return formattedDate; }, }); This code will format the date according to the EST timezone (America/New_York) and return it in the format YYYY-MM-DD.

17

Using the Google Drive app, is there a way to get the original date that a document was created?

18

Yes, you can get the original creation date of a Google Drive document using the Google Drive API. Here’s an example Pipedream component that retrieves the creation date of a document using its file ID: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, fileId: { type: "string", label: "File ID", }, }, async run({ steps, $ }) { const url = `https://www.googleapis.com/drive/v3/files/${this.fileId}?fields=createdTime`; const headers = { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }; const response = await axios($, { method: "GET", url, headers, }); const creationDate = response.createdTime; return creationDate; }, }); Replace fileId with the Google Drive file ID you want to get the creation date for. The component will return the creation date in the ISO 8601 format (e.g., “2022-01-01T00:00:00.000Z”).

19

Two things:

  1. I need to output the date in EST, with leading zeros and without the time. So just YYYY-MM-DD.
  2. I’m pulling the files from a SHARED Drive.
    Please adjust the code accordingly.
20

I’ve updated the code to get the creation date of a file in a shared Google Drive and format the date in EST timezone without the time: import { axios } from "@pipedream/platform"; export default defineComponent({ props: { google: { type: "app", app: "google", }, fileId: { type: "string", label: "File ID", }, }, async run({ steps, $ }) { const url = `https://www.googleapis.com/drive/v3/files/${this.fileId}?fields=createdTime&supportsAllDrives=true`; const headers = { Authorization: `Bearer ${this.google.$auth.oauth_access_token}`, }; const response = await axios($, { method: "GET", url, headers, }); const creationDateUTC = new Date(response.data.createdTime); const estDate = new Intl.DateTimeFormat("en-US", { timeZone: "America/New_York", year: "numeric", month: "2-digit", day: "2-digit", }).format(creationDateUTC); const [month, day, year] = estDate.split("/"); const formattedDate = `${year}-${month}-${day}`; return formattedDate; }, }); This code will retrieve the creation date of a file in a shared Google Drive and format it in the EST timezone (America/New_York) without the time, returning the date in the format YYYY-MM-DD.