PROCESIO

Product details

Hi, We have a simple task, as I thought.

Hi, We have a simple task, as I thought. We have linked a forms-based survey to Google Sheets. No problem. Now we need to automate the data transfer from Google Sheets to Excel 365. Once we have the data in Excel, we can use Power Automate to complete our task. Are we going to be able to create the automation from Google Sheets to Excel 365? Either every time a new line appears in Google Sheets or can we program it to have a look for new items every x minutes?

aboli27
| Deals Bought: 203 | Member Since:
    Andrei_PROCESIO
    Andrei_PROCESIOFounder team
    Verified Purchaser
    | Member Since:

    Hi aboli27,

    Great question, thanks for posting. Firstly, I recommend that you post these types of questions in our Discord channel. Several members of our community can assist you and provide you with best practices, and even help you with your implementation. (Sometimes there may be some delays, but it's worth waiting for.)

    Going back to your questions:

    -I'm 100% confident that the approach with a schedule will work (checking every x minute).
    -As for the second approach, I'm not entirely sure, but I anticipate that it will work too. However, this approach is highly dependent on the Google Sheets API. (I remember to have read that they have an enpoint covering your need)

    Once again, if you start your implementation and need guidance, Discord is the place to be, and we'll do our best to get you all set. Here is our Discord: https://discord.com/invite/CEBuKgJefv

    Regards,
    Andrei