Create Automatic Pivot Tables in Google Sheets with n8n

This n8n workflow pulls campaign data from Google Sheets and creates two pivot tables automatically each time it runs. --- ### Step 1: Connect Google Sheets 1. In n8n, go to **Credentials** and click **New Credential**. 2. Select **Google Sheets OAuth2 API**. 3. Log in with your Google account and authorize access. 4. Use this sheet: [Campaign Data Sheet](https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ/edit?usp=sharing). 5. Make sure the sheet includes: - A **Data** tab (row 1 = headers, rows 2+ = campaign data) - A tab for each **pivot view** (e.g., by Channel, by Campaign). --- ### Need Help? Feel free to reach out: - robert@ynteractive.com - [LinkedIn](https://www.linkedin.com/in/robert-breen-29429625/)