with Google Search Console and Amazon SES?
Fetches search analytics from Google Search Console for a verified site.
Create a HTML or a plain text email template. See the docs
Sends a URL update notification to the Google Indexing API
Send an email using Amazon SES. Supports simple email messaging. See the docs
The Google Search Console API opens a treasure trove of data and insights about your website's presence in Google Search results. You can get detailed reports on your site's search traffic, manage and test your site's sitemaps and robots.txt files, and see which queries bring users to your site. On Pipedream, utilize this API to automate checks on site performance, integrate with other tools for deeper analysis, or keep tabs on your SEO strategy's effectiveness.
Google Search Console distinguishes between URL properties and Domain properties:
https://example.com
or https://www.example.com
)sc-domain:example.com
)When working with subdomains:
sc-domain:example.com
)https://mcp.example.com
)https://mcp.example.com/app/slack
This approach ensures you can access subdomain data even if the subdomain isn't individually verified in Search Console.
To see data broken down by individual pages (rather than just aggregate data):
For advanced filtering needs, you can also:
SEO Performance Report to Slack: Automate daily or weekly SEO performance reports. Use the Google Search Console API to fetch search analytics data, then send a summary report to a Slack channel, keeping the team informed about trends, keyword rankings, and click-through rates.
Sync Search Results with Google Sheets: Create a workflow that periodically pulls data from the Google Search Console API and adds it to a Google Sheet. This is useful for maintaining an evolving dataset for deeper analysis, historical reference, or sharing insights across teams without giving direct access to the Search Console.
Automatic Sitemap Submission: Set up a Pipedream workflow that triggers whenever a new sitemap is generated in your content management system (CMS). The workflow can then automatically submit the sitemap to Google Search Console via API, ensuring Google has the latest structure of your site for crawling and indexing.
import { axios } from "@pipedream/platform"
export default defineComponent({
props: {
google_search_console: {
type: "app",
app: "google_search_console",
}
},
async run({steps, $}) {
return await axios($, {
url: `https://www.googleapis.com/webmasters/v3/sites`,
headers: {
Authorization: `Bearer ${this.google_search_console.$auth.oauth_access_token}`,
},
})
},
})
Amazon Simple Email Service (SES) is a powerful cloud-based email sending service designed to help digital marketers and application developers send marketing, notification, and transactional emails. With the SES API, you can reliably send emails at scale, manage sender reputations, view email sending statistics, and maintain a high deliverability rate. Leveraging Pipedream's capabilities, you can integrate SES seamlessly into serverless workflows, automate email responses based on triggers from other apps, and analyze the effectiveness of your email campaigns by connecting to data analytics platforms.
module.exports = defineComponent({
props: {
amazon_ses: {
type: "app",
app: "amazon_ses",
}
},
async run({steps, $}) {
const AWS = require("aws-sdk")
const { accessKeyId, secretAccessKey } = this.amazon_ses.$auth
const ses = new AWS.SES({
accessKeyId,
secretAccessKey,
region: 'us-east-1',
})
const sesParams = {
Destination: {
ToAddresses: ["<your email here>"],
},
Message: {
Body: {
Html: {
Charset: "UTF-8",
Data: "<h1>This is a test</h1>",
},
Text: {
Charset: "UTF-8",
Data: "This is a test",
}
},
Subject: {
Charset: "UTF-8",
Data: "Test email",
}
},
Source: "<your from address here",
};
this.resp = await ses.sendEmail(sesParams).promise()
},
})