---
title: "Working with Pivot Tables in Google Sheets using Google Apps Script"
author: "Martin Hawksey"
date: 2020-10-05T14:07:00+00:00
modified: 2020-10-05T14:40:57+00:00
canonical_url: https://pulse.appsscript.info/p/2020/10/working-with-pivot-tables-in-google-sheets-using-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2020/10/working-with-pivot-tables-in-google-sheets-using-google-apps-script.md
categories:
  - "Sheets"
  - "Solutions"
  - "V8"
tags:
  - "hawksey.info"
featured_image: https://pulse.appsscript.info/files/2020/10/pivot-macro.gif
description: "Pivot tables are a quick and powerful way to analyse data. Using Google Apps Script, there is an ability to build and modify pivot tables in Google Sheets. In this post I’ll share some tips and tricks for interacting with pivot tables in Google Sheets."
---

# Working with Pivot Tables in Google Sheets using Google Apps Script

![Working with Pivot Tables in Google Sheets using Google Apps Script](https://pulse.appsscript.info/files/2020/10/pivot-macro.gif)

> [https://mashe.hawksey.info/2020/10/working-with-pivot-tables-in-google-sheets-using-google-apps-script/](https://mashe.hawksey.info/2020/10/working-with-pivot-tables-in-google-sheets-using-google-apps-script/)
> Pivot tables are a quick and powerful way to analyse data. Using Google Apps Script, there is an ability to build and modify pivot tables in Google Sheets. In this post I’ll share some tips and tricks for interacting with pivot tables in Google Sheets.

Source: [Working with Pivot Tables in Google Sheets using Google Apps Script**](https://mashe.hawksey.info/2020/10/working-with-pivot-tables-in-google-sheets-using-google-apps-script/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2020/10/working-with-pivot-tables-in-google-sheets-using-google-apps-script/](https://pulse.appsscript.info/p/2020/10/working-with-pivot-tables-in-google-sheets-using-google-apps-script/)*