Import Hidden Excel Worksheets

Import Hidden Excel Worksheets

Hi All,

Seems a bit of a simple one however I have ran into some difficulty, we are wanting to automate the import of our sales data from our Point of Sale system into Zoho Analytics.

Due to other complexities the only method that we can achieve this is through automatic email that we then want to forward into Zoho Analytics.

However the main data table with the data is hidden, I have tried using Power Automate, Pipedream to unhide the sheet within the excel document.

Anyone have any suggestions?