Automating Image Transfer from Google Drive to Dropbox via Google Sheets

Getting Started
1

Hi everyone,

As a newbie to Make.com, I need guidance on setting up automation. Here’s my current workflow:

  1. I have a Google Form that allows users to upload images as part of their responses.
  2. The responses, including links to the uploaded images, are recorded in a Google Sheet.
  3. The images are automatically saved in Google Drive.
  4. I want to automate taking these images from Google Drive and uploading them to Dropbox.

So far, I’ve set up a scenario to:

  • Watch rows in the Google Sheet to identify new responses.
  • Extract the image link from the sheet.

However, I’m stuck on how to:

  • Properly download the image from Google Drive using the link.
  • Pass the downloaded image to the Dropbox module for upload.

I’d greatly appreciate your advice if anyone has done something similar or knows the best approach to achieve this!

Thank you in advance for your help!

2

Hello @Willie_Wilkins, we are a make certified partner and can help you with this setup you can schedule a call Here , so we can put you through this and the make.com interface as a whole

3

Hi @PathfinderAutomate,

I am sure this is an honest mistake, but please refrain from offering paid services in other categories than the Hire a Pro category, as per the Community Guidelines.

Cheers,
@Henk-Operative

1 Like
4

Update: Solved!

I figured out the solution to my issue. Here’s how I got it working:

  1. Instead of trying to manipulate the Google Sheets data, I worked directly with the Google Form responses.
  2. I used the “Download a File” module from Google Drive. The key was to specify the File ID to download the correct file.
  3. The File ID isn’t directly available in the initial Google Sheets entry. In the Google Forms module, I had to drill down into the field answers to extract it.
  4. Once I had the File ID, I could successfully download the file and then upload it to Dropbox using the Dropbox module.

Thanks to everyone who considered helping out!

1 Like