I tried adding a '/' between the folder and filename like. Folder name: Jobs Completed-Week33įilename: _22 Hajjee, Primindia Brits.pdf Im not sure if the folder/file name is written properly.

Here is the Folder with the subfolders and the file that does the extraction from the main table: Then here is the file inside the folder. Step 2: On the window that comes up, click Get. All seems to work fine, but then I get the feared 'BAD REQUEST' when trying to open the link.Īlso, I'm not sure how safe it is to give public access to this link. Step 1: Go to Google Drive and right click the file that you want to share.

This sheet extracts the relevant values out of the main table (including the url value) through a query. I'm storing the file name and url value inside the main table, then I have an external sheet in the Drive directory where the folders for the PDF files resides.

CONCATENATE (' IDCELL) Replace IDCELL with the cell from the Id column which is in the same row. choose Copy link from the dialog box above (if still visible on your screen), or right-click on the file and choose Get link (see screenshot below) then select Copy link from the pop-up box, or select the link option displayed to the right (see screenshot below) then select Copy link from the pop-up box. Get started Read a technical overview of this. In the first empty cell of the URL column, paste the formula below. Not sure if I'm doing something wrong though. The Drive API is used to interact with Google Drive storage, and supports several popular programming languages, such as Java, JavaScript, and Python.

Google drive url link