Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I have a form on my website that allows users to upload up to 10 images. Users can submit anywhere from 1 to 10 images at a time. On submission, I have a Zapier integration set up to map the fields to my Google Sheets.

 

My Setup

• I’m using the Formatter by Zapier with the following steps:

• Event: Text

• Action: Split Text (to split the image URLs).

• The split outputs are then mapped to the corresponding image fields in Google Sheets.

 

What’s Working

• In a test scenario with a full submission of 10 images, the Zap processes correctly. It posts the images to Google Sheets when I run a test Zap using sample data.

 

The Issue

• In live submissions (whether it’s 1 image or 3 images), the images fail to post to Google Sheets.

• I’ve tried different configurations for splitting the image URLs and mapping them, but none seem to resolve the issue.

 

Attached are screenshots of the different ways I’ve attempted to configure the Zap, but none have worked so far. I’m unsure what I’m missing and would appreciate guidance on how to resolve this issue. 

 

 

Hi @Ben24 

For us to have more info, post screenshots showing the DATA OUT from Zap step 1 for the field that has the image links so we can see how those are formatted.

Here you go

 

@Ben24 

Post screenshots showing the DATA OUT from Zap trigger in Step 1 for the field that has the image links so we can see how those are originally formatted.

 

 

@Ben24 

Your issue stems from how the data is returned from the Zap trigger step app when in EDIT mode VS when in LIVE mode.

 

For LIVE Zap Runs the data is returned as an array of items.

 

Try using this Zap action (x10): Formatter > Utilities > Pick from List

For the Operation, change to “Custom” mode via the i...] button.

Then use numbers 0-9.

0 will get the first item in the list, 1 will get the second item in the list, and so on.

e.g. In the screenshot below, 0 will return an output variable with a value of: 111

 

You will have to turn the Zap ON to test this LIVE due to the issue with the different data format in EDIT mode.

 

 

That worked! Thank you so much!!

Hi @Ben24,

 

Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.

Reply


Terms & Conditions