Index a new google doc in a google sheet: url doesn't appear

[Paloma_Alma]

Hi there!

I have a few automatizations on Zapier and I’m seeing if I can use them on activepieces.

The one I’m having trouble with is the following:
Everytime I create a new google document in a certain folder, I want it to be included in an excel that I use as an Index.

I’m having 2 problems:

1. The info that appears on column 3 when I set up, goes to column 2.
2. I don’t see how to choose the url of the new document, this is the most important info I want to include in the excel. In zapier this info is called: “embed link”. In activepieces I just see the tail of the url (ID info) but I cannot choose a whole url.

I just see this:

In zapier, the same flow shows more options, like this:

Can anyone help me?

If this isn’t available in Activepieces, I’m afraid I’ll stick with zapier.

Thaks!!!

[ashrafsam]

Hi @Paloma_Alma and welcome to Activepieces!

1. The info that appears on column 3 when I set up, goes to column 2.

Can you elaborate more on this? I don’t get what it means.

2. I don’t see how to choose the url of the new document, this is the most important info I want to include in the excel. In zapier this info is called: “embed link”. In activepieces I just see the tail of the url (ID info) but I cannot choose a whole url.

This makes sense, I heard it from other users too and I think we should fix it. I’ll check this with our pieces team and let you know.

[Paloma_Alma]

sure! i’ll elaborate problem number 1 a little bit more:

So when setting it up, I just fill information for columns A and C:

But when I go to the sheet, the info that should go into column C, appears in column B as you can see here:

This is how it should appear:

Column be is meant to be manually updated.

Thanks very much for your help!

[abuaboud]

Google Drive should return the URL now

[Paloma_Alma]

don’t see it yet, under what name? I just see these:

ID:
kind:
name:
mimeType:

[kishanprmr]

@Paloma_Alma You need to use latest version of Google Drive piece. It’s v0.5.2.

You can reconfigure Google Drive Trigger for latest version.

[Paloma_Alma]

yaaay it worked thanks!!!

i use this flow a lot to index all of my content.

regarding to the other issue, I found that if I don’t select anything, the system will fill my column B with column C. Because if i just fill the column B with “name” tag again, then bothe A, B and C columns have something to show.

Is there anyway I can write something like N/A to fill that gap in the automatization? I hope I explained myself properly.

Thanks a lot