Convert Google Drive Image Links to Dropbox URLs for Notion DB Using ActivePieces

Need help
1

I am looking for a way to automate the conversion of Google Drive image links into Dropbox direct URLs so they can be used in a Notion database.

The issue: Notion does not display image previews for Google Drive links, while direct URLs from Dropbox work correctly. This means that when adding Google Drive image links to a Notion database, the images are not visible as previews.

Proposed solution: I would like to use ActivePieces to create a workflow that:

  1. Reads Google Drive image links from a Google Sheet
  2. Downloads the images from Google Drive
  3. Uploads them to Dropbox
  4. Retrieves the direct Dropbox URLs and updates the Google Sheet

The challenge: I am unsure how to structure the ActivePieces workflow to:

  • Download an image from Google Drive
  • Upload the image to Dropbox
  • Obtain the direct Dropbox URL for the uploaded image

Has anyone implemented a similar solution or has experience with setting up these steps in ActivePieces? Any guidance would be appreciated.

2

what is column type for this field in notion?

Do you want the links to be updated in Notion or Google Sheets?

3

The column type is “File & Media”.

4

I want first update the link in Google Sheet and after that sync the Google Sheet with the Notion DB having the preview of the image (column type File & Media). If i find a solution to show the preview of the image in the Notion DB using the google drive url, i don’t need anymore to create an url with Dropbox.
Thanks again for your time