---
title: "How to build an automated PDF report in Google Sheets using Apps Script "
author: "Martin Hawksey"
date: 2022-03-09T22:09:21+00:00
modified: 2022-03-09T22:09:25+00:00
canonical_url: https://pulse.appsscript.info/p/2022/03/how-to-build-an-automated-pdf-report-in-google-sheets-using-apps-script/
markdown_url: https://pulse.appsscript.info/p/2022/03/how-to-build-an-automated-pdf-report-in-google-sheets-using-apps-script.md
categories:
  - "Beginner"
  - "Sheets"
  - "Solutions"
  - "V8"
tags:
  - "@benlcollins"
  - "benlcollins.com"
featured_image: https://pulse.appsscript.info/files/2022/03/autoEmail_800.jpeg
description: "Ben Collins shares the solution he uses to produce a daily 'ConvertKit' PDF report. Even if you don't use ConvertKit this post is still worth a read as the basic model of getting data from a third party API into Google Sheets and sending a PDF summary could come in handy. Perhaps not surprising given this post comes from Ben it includes some clever Google Sheet functions to prepare and shape data.  "
---

# How to build an automated PDF report in Google Sheets using Apps Script 

![How to build an automated PDF report in Google Sheets using Apps Script ](https://pulse.appsscript.info/files/2022/03/autoEmail_800.jpeg)

> [https://www.benlcollins.com/apps-script/convertkit-report/](https://www.benlcollins.com/apps-script/convertkit-report/)
> Grab this automated ConvertKit Report in Google Sheets to monitor your email list growth and use it to project your future list growth.

Ben Collins shares the solution he uses to produce a daily ‘ConvertKit’ PDF report. Even if you don’t use ConvertKit this post is still worth a read as the basic model of getting data from a third party API into Google Sheets and sending a PDF summary could come in handy. Perhaps not surprising given this post comes from Ben it includes some clever Google Sheet functions to prepare and shape data.

Source: *[Automated ConvertKit Report In Google Sheets*](https://www.benlcollins.com/apps-script/convertkit-report/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2022/03/how-to-build-an-automated-pdf-report-in-google-sheets-using-apps-script/](https://pulse.appsscript.info/p/2022/03/how-to-build-an-automated-pdf-report-in-google-sheets-using-apps-script/)*