How to notify admin via gmail activity

Help Activities
, ,
1

Hello everyone
I have a difficult to notify an admin about changement in excel file via gmail or outlook to magke him updated to all changements made in a file
o how can i solve this please

2

@Lounis_Merabet1,

The solution will be depend on the storage location of the file. If it’s online like Google Drive or One Drive, you should be using Integration Services for this.

Thanks,
Ashok :slight_smile:

3

the storage location is excel file and extract changement from web to store then in excel file and i went to notify the admin about these changements

4

@Lounis_Merabet1,

Do you mean the Excel is saved on local storage where bot will be running and your bot have to keep monitoring for the excel file modification?

Thanks,
Ashok :slight_smile:

5

yes i run have made a comparaison methode to compare the old excel file with th current data and i want to send those changement to the admin

6

@Lounis_Merabet1,

For initial email your whole file would be updated so you will be sending whole file to admin. When sent keep a copy to some secret or dedicated location like a backup folder where no one else would have access if the system is used by other users for next run.

For next run check if a file available at backup location. If available, read it into DataTable, read file original/Updated file into datatable.

Compare both the file DataTable and get rows which are not available in the backup file.

That’s your updated data. Send it in email and again overwrite the backup file with current updated file.

Thnaks,
Ashok :slight_smile:

7

but the process of comparaison is done i want just to send an email to meke the admin updated about changements

8

@Lounis_Merabet1,

You can use Gmail activities. Follow this tutorial for exact setup.

Thanks,
Ashok :slight_smile: