I want to copy and paste the pivot table from google sheet to email Body. how to do that?

Help StudioX
,
1

I want to copy and paste the pivot table from google sheet to email Body.
How to do that?

2

hello @Barry_Liu
if you can read that datatable in UiPath as a varibale then you can pass it via HTML Code as a mail body.

3

Hi @Barry_Liu

Use activities such as “Type Into” and “Click” to navigate to the Google Sheets file containing the pivot table, then use the “Send Hotkey” activity to select the entire pivot table. You can use the Ctrl+A (or Command+A on Mac) hotkey combination for this.

Use the “Send Hotkey” activity to copy the selected pivot table. Use the Ctrl+C (or Command+C on Mac) hotkey combination. Open your email client or webmail in the browser using the “Open Browser” activity. Use the appropriate activities to compose a new email or navigate to the email body field.

Use the “Send Hotkey” activity to paste the pivot table into the email body. Use the Ctrl+V (or Command+V on Mac) hotkey combination.Optionally, format the email body or add additional text or information as needed.Use the appropriate activities to address the email, set the subject, and send it.

Thanks!!

1 Like