Skip to content
NEWError doctor and Watchtower: failed n8n runs explained in plain words, and emailed to you. See what is new

Library / Reports, Analytics & Dashboards

Reports, Analytics & Dashboards

Report Weekly Google Analytics Stats to Baserow

On a schedule, it compares this week's and last week's Google Analytics page engagement and saves the stats into Baserow.

What it does

# Google analytics template ## Overview Automated workflow: Google analytics template. This workflow integrates 8 different services: stickyNote, httpRequest, code, scheduleTrigger, googleAnalytics. It contains 34 nodes and follows best practices for error handling and security. ## Workflow Details - Total Nodes: 34 - Node Types: 8 - Error Handling: ✅ Implemented - Security: ✅ Hardened (no sensitive data) - Documentation: ✅ Complete ## Node Breakdown - Schedule Trigger: scheduleTrigger - When clicking ‘Test workflow’: manualTrigger - Sticky Note: stickyNote - Sticky Note1: stickyNote - Get Page Engagement Stats for this week: googleAnalytics - Get Page Engagement Stats for prior week: googleAnalytics - Parse data from Google Analytics: code - Parse GA data: code - Get Google Search Results for this week: googleAnalytics - Get Google Search Results for last week: googleAnalytics - ... and 24 more nodes ## Usage Instructions 1. Configure Credentials: Set up all required API keys and credentials 2. Update Variables: Replace any placeholder values with actual data 3. Test Workflow: Run in test mode to verify functionality 4. Deploy: Activate the workflow for production use ## Security Notes - All sensitive data has been removed or replaced with placeholders - Error handling is implemented for reliability - Follow security best practices when configuring credentials ## Troubleshooting - Check error logs if workflow fails - Verify all credentials are properly configured - Ensure all required services are accessible

The steps

  1. Schedule Trigger
  2. When clicking ‘Test workflow’
  3. Get Page Engagement Stats for this week
  4. Get Page Engagement Stats for prior week
  5. Parse data from Google Analytics
  6. Parse GA data
  7. Get Google Search Results for this week
  8. Get Google Search Results for last week
  9. Parse Google Analytics Data
  10. Parse Google Analytics Data1
  11. Get Country views data for this week
  12. Get Country views data for last week
  13. Parse Google analytics data
  14. Parse Google analytics data1

52 steps in total.

Similar automations