In animal protection, I want to automate lost ferret announcements using a Google Form. Each response is entered into a Google Sheet. I then inserted a Google Drive module and created a post with a photo on Facebook. The problem is that I don’t think I selected the right item, so I can’t retrieve the photo from Facebook. I automatically published a thumbnail photo from my Google account or an image from my form. Which item should I select? Thank you for your help.
It seems that the Facebook module is retrieving the wrong image, as it is associated with the account’s default thumbnail or a non-image field in your form. In Make, when you connect your Google form to Google Sheets, the photo upload is usually stored as a file URL (often in a specific column). Here’s my suggestion: In your Google Sheets spreadsheet, identify the exact column where the uploaded photo link is stored. In the Facebook “Create Photo Post” module, make sure to map the value of that column (the actual URL of the uploaded image) to the “Photo URL” or “Source URL” field, not to your account photo or other default fields. If the form only stores the file in Google Drive, first use the Google Drive “Get a file” module to retrieve the public link of the uploaded file, then pass it to Facebook. Once this setting is defined, you should be able to post the actual photo from the form instead of your thumbnail.
Hello, thank you for your reply. However, I am unable to select a single column; this option is not available in the items. I can’t do it. I started a week ago and nothing works.