Trouble Sending Multiple Google Drive Image URLs to Buffer via Zapier

Question

Hi everyone,I'm trying to automate social media posts using Zapier by sending multiple image URLs from Google Sheets to Buffer. The images are stored in Google Drive, and the URLs are in this format:https://drive.google.com/uc?export=view&id=FILE_IDWhen I use a single image URL, it works fine. But when I try to send multiple images (using Zapier’s “Multiple Images” option in the Buffer action), I get an error saying the URLs must be direct image links.The files are publicly shared, and I’ve confirmed the links work when used individually. I suspect the issue might be with how the URLs are being passed—possibly Zapier isn’t formatting them as an array of separate items?Has anyone successfully sent multiple Google Drive images to Buffer using Zapier? Any ideas on how to structure the data or fix this?Thanks in advance!

The New Materialist · Accepted Answer

I solved it!I added some intermediate Google Drive Get file action to convert the google file ID from the sheet into actual file that are passed to buffer.

Troy Tessalone · Answer

Hi ​@The New MaterialistIt’s likely the image urls need to be structured as an array of items rather than a comma separated string of text.Try adding this Zap action: Formatter > Utilities > Text to Line ItemsIf you need more help, post screenshots showing how your GSheet is configured, how your Zap steps are configured, and the encountered error.

Useful links

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded