I’m trying to send automated monthly reports through Zapier that pull information from Google Sheets. The reports contain basic metrics like performance scores (example: 3.8/5) and completion percentages (example: 92%).
Since Zapier only supports Gmail for email delivery, I need to use HTML format for any visual elements. I want to create charts that update automatically with the data, so static images won’t work since these go out to about 40 recipients.
I found some pure HTML chart code online and tried using it, but I’m having display issues. The chart shows up fine on my iPhone’s native mail client, but it won’t appear in Gmail on desktop browsers or the Gmail mobile app.
<head>
<title>Data Chart</title>
</head>
<style>
.chartWrapper {
height: 120px;
}
.chartBase {
background-color: #888;
position: absolute;
width: 120px;
height: 120px;
border-radius: 60px;
box-shadow: 0px 2px 4px #333;
}
.segment {
position: absolute;
width: 120px;
height: 120px;
border-radius: 60px;
clip: rect(0px, 60px, 120px, 0px);
}
.container {
position: absolute;
width: 120px;
height: 120px;
border-radius: 60px;
clip: rect(0px, 120px, 120px, 60px);
}
#section1 .segment {
background-color: #2a5cb8;
transform: rotate(120deg);
}
#section2 {
transform: rotate(120deg);
}
#section2 .segment {
background-color: #d4c394;
transform: rotate(50deg);
}
#section3 {
transform: rotate(170deg);
}
#section3 .segment {
background-color: #dd1122;
transform: rotate(80deg);
}
#section4 {
transform: rotate(250deg);
}
#section4 .segment {
background-color: #bb22dd;
transform: rotate(110deg);
}
</style>
<div class="chartWrapper">
<div class="chartBase"></div>
<div id="section1" class="container"><div class="segment"></div></div>
<div id="section2" class="container"><div class="segment"></div></div>
<div id="section3" class="container"><div class="segment"></div></div>
<div id="section4" class="container"><div class="segment"></div></div>
</div>
Has anyone dealt with this Gmail compatibility issue before? Since all my recipients use Gmail, I really need this to work there. Any ideas or alternative approaches would be great.