Hi @blazersfan77 

Try this Zap action: GDrive - Copy File

Set convert to Document to true, which will convert files to Google Apps Format. (e.g. GDoc, GSheets, GSlides)

Super helpful! Not sure where the issue lies within my flow now that I’ve implemented what you recommended.

When I drop an excel sheet to test for my trigger, it gets to the sheets step and cannot find the file that was copied - here are some screenshots:

 

Any thoughts?

@blazersfan77 

We would need to see how your Zap steps are configured in EDIT mode for the “Configure” section.

Error indicates you have a Worksheet ID selected that is not valid for the selected Spreadsheet ID.

Try using ID: 0

Using ID: 1 worked (I couldn’t find ID: 0)! 

But Now I’m having trouble getting the Google Sheets: Get many Spreadsheet Rows step through without hiccups:

 

Here is the configuration I have within the edit mode:

 

For context: There are no intentions to use any other name for the worksheet besides “Sheet1.” 

Any ideas?

@blazersfan77 

Try using the ...] button to switch to “Custom”, then set a value of: 0

When you duplicate the spreadsheet the worksheet should have an internal worksheet ID of 0.

This is my configuration now:

 

When I test the above:

 

​​​

@blazersfan77 

Ok, try adding this Zap step before: GSheets - Find Worksheet

Title: Sheet1

So, testing that in the editor worked great! When I published and gave it a go though…

 

Any ideas?

@blazersfan77 

Check your Zap Runs history details to see the DATA IN/OUT for each step, plus tabs for Troubleshooting and Logs to help you make sense of the encountered error: https://zapier.com/app/history/

Make sure the combo of Drive/Folder/File are valid.

Step 3 is trying to copy the file from Step 1.

Are you trying to copy the file from Step 1 or from Step 2?

I’ve taken the record that’s been giving me the error and have been trying to troubleshoot within the editor. Troubleshooting has led me to believe it has to do with some sort of incorrect mapping with the ID:

 

Side note: one thing that’s bothering me a lot is the fact that in my first step, it’s not letting me select “My Google Drive” for drive. Everywhere else, it’ll accept that click, but every time I click, NOTHING happens. I’ve tried reconnecting the account - still nothing. 

 

@blazersfan77 

My Google Drive is the default Drive with no ID available which is why it won’t stay selected.

@blazersfan77 

TIP: In the Zap Editor, when testing, make sure to retest each Zap step, to ensure you are using current valid data, and not a GDrive File that was deleted.

Looks like you updated your Zap Step 3.

Try publishing the Zap and testing again live, then check your Zap Runs: https://zapier.com/app/history/

Ahhh I didn’t know that haha, thanks Troy. 

For Zap Editor testing, I get what you’re saying! Although I still can’t seem to understand (even with updated data for testing) why this will not work:

 

@blazersfan77 

Did you try this?

Try publishing the Zap and testing again live, then check your Zap Runs: https://zapier.com/app/history/

I was trying to but now I’m having the same issue with the google drive field in the 3rd step…I used to have this selected but now it won’t let me? 

 

It’s saying that the folder “Automated” doesn’t exist in my Google Drive, but it definitely does so I’m a little frustrated

I had to refresh the page and reconnect to Google Drive to finally select the drive. Here’s what I got for you from publishing and testing:

DATA IN:

DATA OUT:
 

Step with error:
 

Troubleshooting:
 

@blazersfan77 

Help links for using GDrive in Zaps: https://zapier.com/apps/google-drive/help

Do the files existing on the same Drive?

Are you using a Shared Drive?

Post screenshots showing how your GDrive/Folders are organized that you are trying to use.

Click the Logs tab to see the underlying API request/response which can often show more details about the error.

The automation triggers with a Gdrive step: “new file in folder”

So when i test, I delete all files and then re-upload them. There are no files currently on the drive. The drive is not shared. Flow for reference:

 

Google Drive for reference:

 

@blazersfan77 

Can you post screenshots showing how Zap step 2 is configured in EDIT mode?

Check to make sure there are no leading/trailing extra spaces before/after the mapped variable.

Sure thing!

 

@blazersfan77 

The issue may be related to the fact that you are trying to use an XLSX file rather than a GSheet spreadsheet format.

So try this…

• For Step 3, instead of Copy File, use Upload File
  • For the File field, map the variable that shows as: (Exists but not shown)
    • That is a file object, which is a temp version of the file that expires after 1 hour
  • Convert to Document = TRUE/YES
  • Folder
    • Select your desired folder
  • File Name
    • Map the Title variable from Step 1
  • File Extension
    • Leave blank
  • Idempotency Key
    • Leave blank
• Remove Step 2, as it is redundant, since the info you need comes from Step 1

I’ve deleted the redundant step so here’s an updated look of that:

 

To your suggestions (thank you for the detail you provided!), I’m still getting this error despite ewhat I believe is me] following your instructions:

 

Here is the configuration for that specific step:

 

​

@blazersfan77 

Did you retest Zap step 1 before testing Zap step 2 to make sure you tested with a fresh file object?

Check the Troubleshoot tab for possible guidance.

I did both of those things!

Here’s the troubleshoot:
 

It’s alluding to the same point you’re making too haha

@blazersfan77 

Things to check try:

• Reselect the Drive
• Reselect the Folder
• Make sure there are no extra spaces before/after the mapped variable for File field
• Reselect Convert to Document?
• Set a variable for File Name
  • Title variable from Step 1