How to copy a table from Google Sheets/Docs to Gmail

[FernandaMiranda]

Hello! Looking for some help

I’m trying to copy a whole table/sheet from google sheets to an email body (GMail). We’re currently using the integration service, and every attempt ends with just the text from the original sheet, not the format

This looks messy and it’s impossible to read, any advice?

[ashokkarale]

@FernandaMiranda,

You will have to read the Google sheet data into a datatable and then prepare a HTML string as per your formatting requirement and then pass it to email body.

You can also directly pass the Datatable like explained here.

How to send dynamic and multiple table in email body

@satish.rathi59 Use create html content activity.Click on Open editor in create html content,and then click “add data value” and then “Map values” and then “Add Value” and then click “Table” in that pass your datatable [image] you add all datatable data to this and then save Pass the html content activity output in body of send outlook or mail messages activity

Thanks,
Ashok

[mkankatala (Mahesh Kankatala)]

Hi @FernandaMiranda

Check the below thread for your reference,

How to send dynamic and multiple table in email body

Hi @satish.rathi59 You can use Create HTML content activity to create the body and insert table and save the output in a Variable. Pass this output in Body field in Send outlook mail message or Send SMTP activity and check the IsBodyHTML option in properties. → Use the Read Range workbook activity to read the excel and store in a datatable variable. → Click on the Open editor option in Create HTML content activity a window popsup. → In that window, click Add data values, and click on Add …

Hope it helps!!