Stop guessing what moved your traffic this week. Get a weekly SEO report built from your real data, compared week over week, and saved in a place your team can use. Great for marketers and content teams that want clear insight without manual work.

On a weekly schedule or by running a test, the flow pulls Google Analytics page engagement, landing page metrics, and country views for the current week and the prior week. Code steps organize and compare the results. Three HTTP requests send page, search, and country datasets to an AI service that writes plain language insights. The final summary and key numbers are saved to a Baserow table so your team can read and track changes over time.

You will need Google Analytics access, an OpenRouter API key, and a Baserow table with fields for Name, Country Views, Page Views, Search Report, and Blog. Set your Google Analytics property ID, add the AI key as a Bearer token, and point the Baserow node to your table. Many teams cut weekly reporting from hours to minutes and make faster SEO and content choices based on consistent data.

• Weekly schedule trigger with manual test option
• Pulls Google Analytics page engagement, landing page, and country views for this week and last week
• Code nodes compare week over week results and format the data
• Sends three datasets to an AI service for clear written insights
• Saves the summary and key numbers to a Baserow table
• Configurable property ID and return all metrics for full coverage

• Reduce weekly SEO reporting from 3 hours to 10 minutes
• Automate up to 80 percent of repetitive data prep
• Improve data accuracy by removing copy and paste errors
• Unify page, search, and country data in one report
• Scale to many pages without extra manual effort

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with Google Analytics, OpenRouter and Baserow. See the Tools Required section above for links to create accounts with these services.
3. In the n8n credentials manager, create Google Analytics OAuth credentials. If unsure, double click any Google Analytics node, choose 'Credential to connect with', click 'Create new credential', and follow the on screen steps to sign in and grant access.
4. Open each Google Analytics node and set your property ID. Make sure it matches your GA4 property. Keep the date ranges as configured for week over week comparison.
5. Create an API key in your OpenRouter account. In each HTTP Request node, set Authentication to Header Auth. Use header name Authorization and value Bearer your_api_key with a space after Bearer.
6. Click the HTTP Request nodes and run a test execution. Confirm you receive a 200 status and a text response. Fix any 401 errors by checking the token value and spacing.
7. In Baserow, create a table with columns Name, Country Views, Page Views, Search Report, and Blog. Copy the API token from your Baserow account settings.
8. In the n8n credentials manager, add a Baserow credential using your API token. Then open the Baserow node and select your base, table, and match the fields.
9. Run the workflow with the manual trigger. Check that GA nodes return data, the code nodes output arrays with this week and last week values, and the HTTP nodes return AI text.
10. Confirm a new row appears in your Baserow table with the summary and metrics. If fields are empty, review the field mapping and data keys in the Baserow node.
11. Enable the workflow and keep the weekly schedule active. Adjust the schedule interval if your reporting cadence is different.
12. If data is missing for last week, verify your GA property ID and permissions. If rate limits occur, add small wait times or run at off peak hours.