Skip to main content

I’m having very non descriptive errors on a number of Zaps that use Excel steps or an Excel trigger.

 

For example, for a Find Row step on Excel, the Zaps are showing this error:

If I go to that URL showed on the error message, it’s just the general info about Zapier-Excel integration.

 

For Excel trigger steps, the error is the following:

 

This error has been going on for at least a couple of days, and it’s preventing key integrations from running.

I have tested the Excel connections on the “My Apps” section, and they all returned Test successful. 

The account being used is the creator and owner of the Spreadsheets to which we need access.

Hi @rkanter 👋

Thanks for flagging this with the Community! I’ve taken a look but couldn’t see and bug reports that match those errors you’re seeing here. So I’m wondering if there might be an issue with the spreadsheet itself.

Was the spreadsheet renamed recently? If so, it could be that renaming it caused a disconnect with your Zap. In which case can you try reselecting the spreadsheet in the relevant trigger and actions steps to see if that gets rid of those errors?

Looking forward to hearing from you on this!


Hi @rkanter 

Good question.

Please post screenshots with how your Zap step is configured to help give us context, thanks.


Hi @SamB , the Excel spreadsheet hasn’t been renamed. As for reselecting the spreadsheet, I am not able to do it because the step is not loading all my spreadsheets. The spreadsheet's name starts with ‘Z’, and I’m only able to load 58 items, so up to the ones that start with a ‘D’ (see pic below).

 


@rkanter 

Try to use the Custom option to set the Spreadsheet ID.

 


Hi @Troy Tessalone , attaching screenshots of configured steps.

 

This is for the one that is a trigger:

 

This is for the one that is a “Find Row” step:

 

They are both returning a “Unable to process request” error. 


@rkanter 

Have you reviewed the available Excel help articles: https://zapier.com/apps/excel/help

 

 


@Troy Tessalone I have, haven’t found anything helpful for this matter


Hi there @rkanter,

I’m jumping in to see if I can help!

Have you tried using the Spreadsheet ID of “Zoho Sprints and Desk Automation - For Zapier.xlsx” as a custom value as Troy suggested?

@rkanter

Try to use the Custom option to set the Spreadsheet ID.

 

Here’s an example of the Spreadsheet ID:

9ce5455b04a9e7d9a983935bb99680ad.png
(view larger)

Please give that a try, and keep us posted! 😊


Hi all,

I'm experiencing similar issues where Zapier cannot load Worksheet data (“Unable to load choices
We're having trouble loading 'Worksheet' data. Unable to process request. Learn more about this error: http://zpr.io/6a6q8”) and if I select the worksheet using the ID, it cannot load the columns either (“Unable to load choices
We're having trouble loading 'Lookup Column' data. Unable to process request. Learn more about this error: http://zpr.io/6a6q8”). If I put in a col number manually and run the zap, it will error: “Failed to find or create a find row in Microsoft Excel
Unable to process request. Learn more about this error: http://zpr.io/6a6q8”

The excel file is on OneDrive and is 19MB of size. It feels as if it's unable to get any access to the contents of the file. The name hasn't changed, the file is created by the same owner that logs into OneDrive through Zapier. Does anyone know what else I could do/check to fix it?

Best,

Caspar 

 


Hi @CasparSmits,

I’m so sorry for the delayed response here.

Could you please let me know if you’re still running into an issue with the Zap? If so, could you confirm if the worksheet is password protected or if there might be any restriction that is blocking the connected user from accessing the worksheet?

Please keep me posted!


Hi Ken, 

 

I’m experiencing something similar, where I can connect to the sheet itself but can not load the worksheets within a spreadsheet. The file is 25.9mb and growing on a business one drive account. 

 

Please see error message:

****

No options are available.

Some reasons this could be happening:

  • Confirm if you connected the right account.
  • Confirm that there is data in the partner app.
  • Confirm that you have permission to the data in the partner app.
  • There was an issue retrieving data from the partner app. Please try again later.

*****

 

I’m seeing growing performance issues with the connection to the sheet with over 100 zaps a day timing out when trying to interact with the spreadsheet. 

 

Am pretty desperate to get this back up and running again, please help me! 

 

 

Thanks,

Rob


Having the same issue as the ones above. Any updates here?

I tried switching from ‘Add Row to Worksheet’ to ‘Add Row to Table’ and had a bit more success. When I used Add to table the worksheets loaded but not the table field.

add row to worksheet
add row to table - worksheet field
add row to table - table field

 


Hi folks! 👋

I did some digging and found a bug report related to these issues in not being able to load worksheets in Add Row (Microsoft Excel) actions and timing out. While we can’t provide a timeline for a fix, I’ve added everyone here that’s been experiencing these issues to the bug report as an affected user, so you’ll all be notified via email as soon as it’s sorted.

It’s been noted that the issue appears to stem from the workbook (spreadsheet) containing a large number of worksheets, which is causing timeouts in the Zap editor. So the reported workaround is to:

  1. Create a new workbook in Microsoft Excel.
  2. Copy the desired worksheet from the original workbook to the new workbook.
  3. Then select the new workbook in Zapier when setting up the 'Add Row' action.

Alternatively, you might want to consider archiving any of the existing worksheets that are no longer needed, or switching to a different spreadsheet or more database-like app such as Zapier Tables.

@Aidan Young - the similar behaviour you’re seeing for the Table field on that Add Row to Table action might be related to the same issue, but would be best to reach out to our Support team about that to have it investigated further in case a separate bug report needs to be created for that. You can contact them here: https://zapier.com/app/get-help.

Thanks for everyone’s patience on this, I do hope that one of those workarounds helps to get things up and running in the meantime! 🤞


Reply