• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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