Library / Reports, Analytics & Dashboards
Reports, Analytics & Dashboards
Optimize SEO with Search Console, Analytics and OpenAI
When you run it, this reads a sitemap, pulls Google Search Console and Analytics data and has OpenAI suggest optimizations, emailed via SMTP.
What it does
- sitemap_url - self exlpainatory - search_console_selector - for example "sc-domain:sailingbyte.com" but can be URL aswell- depends on how did you set up your search console - analysis_start_date and analysis_end_date - date range for analytics, by default last 30 days - analytics_selector_id - ID of Google Analytics setup, it is a large integer, you can find it in analytics url preceeded with letter "p", ex (your number is where there are X's): https://analytics.google.com/analytics/web/#/pXXXXXXXXX/reports/intelligenthome - report_receiver - email which will receive report
The steps
- When clicking ‘Test workflow’
- Loop Over Items
- Enforce Order - Positions Last
- Remove Duplicates
- Get sitemap XML
- Convert to JSON
- Split Out to Table
- Limit for Testing Purposes
- Wait to Comply with API Limits
- Globals - CHANGE ME!
- Get Page GSC Status
- Get Page GSC Stats
- Merge Status and Stats
- OpenAI Chat Model
23 steps in total.
Similar automations
Reports, Analytics & DashboardsExport Google Search Console Data to Google Sheets14 stepsAI Agents & AssistantsChat with Search Console Data Using OpenAI16 stepsAI Agents & AssistantsChat with Search Console Data Using OpenAI and Postgres16 stepsReports, Analytics & DashboardsGoogle Search Console API Examples for Rankings and Cannibalization24 steps