HTTP Request node
+7

Simple Google indexing Workflow in N8N

Published 9 months ago

Categories

Template description

What it does

The workflow is a simple yet efficient way to automate the process of indexing your website on Google using the Google Indexing API.

How it works

It works by extracting information from your sitemap, converting it into a JSON file, and looping through each URL to submit it for indexing.

Here's a brief rundown of the workflow:

  1. The workflow can be triggered manually via the "Execute Workflow" button or scheduled to run at a specific time using the "Schedule Trigger" node.

  2. The sitemap of your website is fetched using the "sitemap_set" node with a HTTP Request to the sitemap URL.

  3. This XML sitemap is then converted into a JSON file using the "sitemap_convert" node.

  4. The "sitemap_parse" node splits the JSON file into individual URLs.

  5. The "url_set" node then prepares each URL to be sent to the Google Indexing API.

  6. A loop is created using the "loop" node to process each URL individually and make a POST request to Google Indexing API indicating that the URL has been updated.

  7. If the POST request is successful and the URL has been updated, the workflow waits for 2 seconds before moving to the next URL.

  8. In case the daily limit for the Google Indexing API is reached (200/day by default), an error message is triggered using the "Stop and Error" node.

Before you use the workflow

Activate the indexing API

  • Create an account with Google Cloud Platform > Console and then create a new project
  • Search for the Indexing API in the Library
  • Activate the API

Create a Service Account and get credentials

  • Open the Service accounts page. If prompted, select a project.
  • Click add Create Service Account, enter a name and description for the service account. You can use the default service account ID, or choose a different, unique one.
  • When done click Create.
  • On the Grant users access to this service account screen, scroll down to the Create key section. Click add Create key.
  • In the side panel that appears, select the JSON format
  • Click Create. Your new public/private key pair is generated and downloaded to your machine.
  • Open the file and copy the private key.
  • Add the credentials in the url_index node

image.png

Add the user as owner of the site

Beware, for each site you need to add the user as a owner like this:

image.png

Set your sitemap

  • Open the sitemap_set node and add the url to your sitemap.

Now you should be able to ensure that Google is always up-to-date with the latest content on your website, improving your website's visibility and SEO rankings, have fun!

Share Template

More Marketing workflow templates

Google Sheets node
HTTP Request node
Merge node
+4

OpenAI GPT-3: Company Enrichment from website content

Enrich your company lists with OpenAI GPT-3 ↓ You’ll get valuable information such as: Market (B2B or B2C) Industry Target Audience Value Proposition This will help you to: add more personalization to your outreach make informed decisions about which accounts to target I've made the process easy with an n8n workflow. Here is what it does: Retrieve website URLs from Google Sheets Extract the content for each website Analyze it with GPT-3 Update Google Sheets with GPT-3 data
lempire
Lucas Perret
Google Sheets node
HTTP Request node
Microsoft Excel 365 node
Gmail node
+5

Automated Web Scraping: email a CSV, save to Google Sheets & Microsoft Excel

How it works: The workflow starts by sending a request to a website to retrieve its HTML content. It then parses the HTML extracting the relevant information The extracted data is storted and converted into a CSV file. The CSV file is attached to an email and sent to your specified address. The data is simultaneously saved to both Google Sheets and Microsoft Excel for further analysis or use. Set-up steps: Change the website to scrape in the "Fetch website content" node Configure Microsoft Azure credentials with Microsoft Graph permissions (required for the Save to Microsoft Excel 365 node) Configure Google Cloud credentials with access to Google Drive, Google Sheets and Gmail APIs (the latter is required for the Send CSV via e-mail node).
mihailtd
Mihai Farcas
HTTP Request node
Merge node
+5

Personalize marketing emails using customer data and AI

This workflow uses AI to analyze customer sentiment from product feedback. If the sentiment is negative, AI will determine whether offering a coupon could improve the customer experience. Upon completing the sentiment analysis, the workflow creates a personalized email templates. This solution streamlines the process of engaging with customers post-purchase, particularly when addressing dissatisfaction, and ensures that outreach is both personalized and automated. This workflow won the 1st place in our last AI contest. Note that to use this template, you need to be on n8n version 1.19.4 or later.
n8n-team
n8n Team

Implement complex processes faster with n8n

red icon yellow icon red icon yellow icon