I want to automate excel refresh based on a condition

[Vignesh_Satheesh1 (Vignesh Satheesh)]

Hi, all I want to refresh an excel file if a mail arrives from a specific person or if a google drive folder gets updated. This use case will happen only once a month. How do I do it? Can someone provide the steps to do it as I am new to UiPath? Thank you

[Nithinkrishna]

Hey @Vignesh_Satheesh1

What do you mean by Refresh Excel please ?

Thanks
#nK

[Vignesh_Satheesh1 (Vignesh Satheesh)]

Excel data refresh

[Sudharsan_Ka]

HI @Vignesh_Satheesh1

For Mail, you are using outlook or what?

Regards
Sudharsan

[Nithinkrishna]

Hey @Vignesh_Satheesh1

Could you please mention the steps for that refresh?

Thanks
#nK

[Vignesh_Satheesh1 (Vignesh Satheesh)]

I am using gmail

[Sudharsan_Ka]

Okay @Vignesh_Satheesh1 try this way

• Get IMAP Mail Message
  Get IMAP messages in UiPath example - YouTube
• For each item in Mail message
  • If Item.Senderaddress.contains(“The Mail address you need”)
    • True-> Do the steps needed

And for refreshing the excel what you need to do is make the excel visible\foreground while running and attach the window and use send hotkey Ctrl +Alt+F5

Actually the shortcut is Alt + Ctrl +F5 you use it either way it works fine I have used in my project

Here is the skeleton for your ref
Main.xaml (11.8 KB)

hope this helps

Regards
Sudharsan