Data Overview
Coupler.io pulls five types of data from Blogger, each corresponding to a different part of your blog. Here's a breakdown of what's available in each entity and the fields you can work with.
Entities
Posts
Published blog posts with content, titles, dates, labels, and metadata
Pages
Standalone static pages within a blog
Comments
Reader comments attached to posts
Blogs
Top-level blog configuration and metadata
Users
Profile data for blog authors and admins
Posts fields
id
Unique post identifier
title
Post title
content
Full HTML content of the post
published
Publication date and time
updated
Date the post was last updated
url
Permalink to the post
labels
Tags/categories assigned to the post
author.displayName
Name of the post author
author.id
Author's Google user ID
blog.id
Blog the post belongs to
replies.totalItems
Total number of comments on the post
status
Post status (live, draft, scheduled)
Pages fields
id
Unique page identifier
title
Page title
content
Full HTML content of the page
published
Publication date
updated
Last updated date
url
Permalink to the page
author.displayName
Page author name
status
Page status (live or draft)
Comments fields
id
Unique comment identifier
content
Text of the comment
published
Date and time the comment was posted
updated
Date comment was last updated
author.displayName
Commenter's display name
author.id
Commenter's Google user ID
post.id
ID of the post the comment belongs to
blog.id
Blog the comment belongs to
status
Comment status (live, spam, pending)
Blogs fields
id
Unique blog identifier
name
Blog display name
description
Blog description
url
Blog homepage URL
published
Date the blog was created
updated
Last activity date
posts.totalItems
Total number of published posts
pages.totalItems
Total number of static pages
Users fields
id
Google user ID
displayName
User's display name
url
Link to the user's Google profile
blogs
List of blogs associated with the user
Common field combinations
Content audit: Posts
title+published+labels+replies.totalItems— see what topics get the most engagementComment moderation log: Comments
content+author.displayName+published+status— review recent or flagged commentsBlog health snapshot: Blogs
posts.totalItems+pages.totalItems+updated— quickly assess activity across multiple blogs
Use cases by role
Export all posts with labels and comment counts to understand which topics resonate most
Track your publishing cadence by pulling
publisheddates into a Google Sheets calendarUse the Append transformation to combine posts from multiple blogs into a single content inventory
Pull post metadata into Looker Studio to visualize publishing frequency and topic distribution
Join Blogger post data with Google Analytics exports to connect content performance to traffic
Send post titles and content to ChatGPT or Claude for automatic tagging, SEO summaries, or content repurposing
Sync blog and post data into BigQuery for long-term archiving and trend analysis
Use the Users and Blogs entities to audit multi-author or multi-blog setups
Automate comment moderation reporting by exporting Comments with status filters into a shared spreadsheet
Platform-specific notes
The Blogger API returns post content as raw HTML — you may need to clean this in your destination if you're analyzing text
replies.totalItemsin the Posts entity reflects the total comment count but does not include individual comment details — pull the Comments entity separately for thatBlogger's API does not return draft posts by default; only published content is accessible via the standard API key flow
If you manage multiple blogs, each blog requires its own Blog ID — use the Append transformation in Coupler.io to consolidate data from several blogs into one dataset
Last updated
Was this helpful?
