Overview
Manually collecting and tracking Xiaohongshu post data is tedious and error-prone. This automation scrapes specified post URLs, extracts key content and interaction metrics, then writes structured rows into a Google Sheet—eliminating manual copy-paste and enabling scalable, accurate data aggregation.
The Impact
- Automate data collection. Batch-scrape multiple Xiaohongshu posts without manual intervention.
- Ensure data accuracy. Extract structured fields like title, author, and interaction counts reliably.
- Centralize reporting. Append or update rows in Google Sheets for seamless analysis.
- Throttle requests. Insert delays to avoid API rate limits and ensure smooth operation.
Who This Is For
- Content Operations Teams managing batch aggregation of social media posts for reporting.
- Data Analysts monitoring campaign KPIs through daily interaction data scraping.
- Brand Managers tracking competitors’ or influencers’ post performance over time.
- Social Media Strategists automating trend analysis from Xiaohongshu content metrics.
How It Works
- Iterate URLs
- Loop through each Xiaohongshu post URL provided in the input list.
- Fetch Post Data
- Send authenticated GET requests using the ApiToken to retrieve raw JSON data for each post.
- Extract and Parse Fields
- Parse JSON to extract title, description, publication time, location, author nickname, and interaction metrics.
- Write to Google Sheets
- Append or update the extracted data as a new row in the specified Google Sheet using authorized credentials.
- Throttle Requests
- Insert a delay after each write operation to prevent API rate limit issues and ensure stable workflow execution.
What You'll Need
Before using this template, make sure you have:
- A list of valid Xiaohongshu post URLs to scrape (one full URL per line).Google Sheets spreadsheet created with a target worksheet containing headers: Post Title, Body Summary, Publication Time, Location, Author's Nickname, Collects, Comments, Likes, Shares.Google OAuth credentials configured for write access to your Google Sheets.A valid ApiToken for Xiaohongshu API access, obtained from your API provider or third-party scraping service.Spreadsheet ID and target SheetName identified from your Google Sheets setup.
How to Use
- Step 1. Prepare URLs
- Step 2. Set Up Google Sheet
- Step 3. Configure Credentials
- Step 4. Input Parameters
- Step 5. Execute and Verify
Compile the full list of Xiaohongshu post URLs you want to scrape.
Create or confirm your Google Sheet and worksheet with the required headers in the correct order.
Ensure Google OAuth credentials are set up to authorize writing to your spreadsheet.
Fill in your ApiToken, list of RedBookUrls, SpreadsheetId, and SheetName into the workflow inputs.
Run the workflow and verify that extracted post data is appended correctly to your Google Sheet.
