I am asked to make a table in DataGrip with the data from excel spreadsheet file being made and updated in Power Automate. I did not make the flow in Power Automate so I have no experience with this. Here is the current flow in Power Automate. As you can see the data in the excel spreadsheet is created by emails being received with data.
Here is what the tables look like in Data Grip I usually pull from look like. I just want to add another table here with the data on the excel sheet. The location of the excel sheet is in our company share point. There you can open it, and see that a row of data is being added every time a new email comes in. So basically just want a new table in DataGrip that is simultaneously having a a row of data being added every time a new email comes in. PLEASE HELP, thank you!
I honestly have not tried much because I have no experience in this. Just watching YouTube videos right now.