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.

Hi everyone,

I'm trying to automate a workflow in Zapier involving Google Drive and Excel. Specifically, I'm using "Find File" (Google Drive) to get multiple files, and I want to generate shareable links for all of them and then write these links into different cells in the same row in an Excel sheet.

Here's what I've tried so far:

  1. Looping by Zapier: It successfully generates links, but it writes each link in the next row, rather than different cells in the same row.
  2. Formatter to Split Files ID: I attempted to split the Files ID into separate values, but when I tried to use Add File Sharing Preference, I couldn't get it to correctly grab the individual File IDs for each link.

Has anyone managed to achieve this kind of setup? How can I generate share links for multiple files and then write all the links in the same row but different cells in Excel? Any help would be much appreciated!

Thanks!

Hi ​@hiro17677,

 

Welcome to the Community.

 

Zapier processes actions linearly, but you can handle lists more effectively by switching to Google Sheets for better integration. Here are some recommendations. You can use Google Drive to generate shareable file links, store them in a single variable with 'Code by Zapier,' split the links using 'Formatter by Zapier,' then write them into separate cells in Excel or Google Sheets. Adjustments may be needed based on your specific setup.

 

We're looking forward to hearing from you soon.

Reply


Terms & Conditions