Skip to main content
Question

Copying and renaming an Excel file in OneDrive after a row update from Jotform


My goal is as follows: 

  1. New submission comes in from Jotform
  2. Jotform data is mapped to update a singular row on excel spreadsheet
  3. When that row is updated, copy the excel file and paste it in another location with a name generated from the Jotform submission in OneDrive

 

This successfully puts a file in the specified folder, but when I go to open it, I get an error saying the file is corrupted, which tells me the file contents are not being copied. The file is also only 1KB rather than the original file size. What am I missing/doing wrong here?

Did this topic help you find an answer to your question?

6 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi ​@Rolland 

Help link for using files in Zaps: https://zapier.com/help/create/basics/send-files-in-zaps

TIP: Click field labels to see tooltips with more info.

The File field expects a file object or a file url, rather than a File Name.

 


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2203 replies
  • February 3, 2025

Hi ​@Rolland,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.


  • Author
  • Beginner
  • 3 replies
  • February 3, 2025
Troy Tessalone wrote:

Hi ​@Rolland 

Help link for using files in Zaps: https://zapier.com/help/create/basics/send-files-in-zaps

TIP: Click field labels to see tooltips with more info.

The File field expects a file object or a file url, rather than a File Name.

 

I’m sorry but this doesn’t really help me nor does the article. How do I “attach” the file. It does not give me an option to


  • Author
  • Beginner
  • 3 replies
  • February 3, 2025
JammerS wrote:

Hi ​@Rolland,
 
We just wanted to see how everything is going with your Zap. Did Troy's recommendation get the job done? Feel free to reach out if you need further assistance with your Zap. We're glad to address any concerns and assist you.
 
We're looking forward to your response.

No it did not, I still don’t know how to attach a file


  • Author
  • Beginner
  • 3 replies
  • February 3, 2025

I also don’t think anyone is understanding the overall issue here besides what I already mentioned about not being able to upload or pick a file. 

I have an existing spreadsheet called “Concrete WIP.xlsx” which is being used as a “template” file. Zapier is supposed to be updating the first row of that spreadsheet and then copy the spreadsheet with the updated data and pasting it into another folder under a different name. There is no direct copy and paste function within Zapier so I assumed “Upload File” was the correct way to do this as there isnt much info on how to do this. If this is wrong then I need someone to help tell me another workflow. I am shocked that this isn’t even listed anywhere as a function as its a pretty common thing to be able to automate. 


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2203 replies
  • February 4, 2025

Hi ​@Rolland,

 

Although Zapier doesn't have a direct copy-and-paste function for files, you can use a workaround with Google Sheets and Google Drive actions. First, set a trigger, then use "Update Spreadsheet Row" in Google Sheets to update data in your file. Next, use "Create Spreadsheet Row" to create a new spreadsheet with the updated data, and finally, use "Copy File" in Google Drive to copy the new spreadsheet to a different folder and give it a new name. While effective, this method may not work perfectly in all cases.

 

I recommend testing this thoroughly to ensure it works as expected. If you need further assistance, please don't hesitate to ask.