How to retrieve some of data that is on an Excel spreadsheet and write only that data on my Googlesheet

What are you trying to achieve?

I want to filter out data from an Excel table my supplier and put it onto my costing Google sheet in a table

Steps taken so far

I have already set up my Googlesheet as a table and begun manually inputting the data. I just cannot connect the Excel Sheet to Make. I could convert it to Google Sheets, and then connect via Drive, but then how do I extract the specific data - here ‘essential oils’ - from the Excel Sheet? And not all organic essential oils.

Screenshots: scenario setup, module configuration, errors

Hi @Blue_Disa and welcome to the Make Community!

I you upload the Excel sheet and convert it to a Google Sheet, you should be able to access the content of that uploaded sheet the same way you would access a regular Google sheet.

Have you tried that? Does your sheet change often?

L