• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Excel Worksheet auto-detection

auto

Member
Hi

I am trying to create a workflow - WooCommerce new Order to Excel.

I was able to connect WooCommerce and connect Excel account, but after the workbook gets auto-selected, I am unable to find worksheet in there to connect. Without worksheet, I cannot see column fields to map the data to.

How to fix this?
Screenshot 2024-03-25 11.21.58 AM.png
 

ArshilAhmad

Moderator
Staff member
Hi @auto,

Could you please confirm whether the Worksheet you are attempting to connect has headers and if the Excel sheet is synced online? Kindly share a screenshot demonstrating the same.
1711394218318.png
 
P

Pabblymember11

Guest
Upon investigating the issue in MS Excel, it seems that you're encountering "You do not have permission to open this file in the browser" when trying to open the file, and when listing the worksheet, you're receiving the "Required authentication information for the resource is either missing or invalid" error messages. We suggest reaching out to the MS Support team for assistance with these issues.
 

auto

Member
The sheet has headers and is synced online as well. I also have the login, so I am assuming I have access and can write to it. Please help ASAP.
 

auto

Member
Upon investigating the issue in MS Excel, it seems that you're encountering "You do not have permission to open this file in the browser" when trying to open the file, and when listing the worksheet, you're receiving the "Required authentication information for the resource is either missing or invalid" error messages. We suggest reaching out to the MS Support team for assistance with these issues.
I have login details and I am able to open it in the browser
 
P

Pabblymember11

Guest
Hey @auto

Can you please create a new sheet with the help of the "Microsoft Excel: Create Worksheet" action step once and then try using the same created sheets with " Microsoft Excel: Add Row To Worksheet"?
 
Top