Overview
Manual tracking of short dramas is slow and error-prone. This workflow automates keyword-based searches, extracts timestamps, titles, and URLs, then logs them into Google Sheets for instant analysis and archiving.
The Impact
- Automate data collection. Eliminate manual scraping and streamline content gathering.
- Centralize records. Consolidate short drama metadata in one accessible Google Sheet.
- Accelerate analysis. Ready-to-use structured data speeds up editorial or monitoring tasks.
- Reduce errors. Automated parsing and validation ensure data integrity.
Who This Is For
- Content Editors needing regular short drama data for curation and planning.
- Product Teams monitoring new short drama releases to track market trends.
- Operations Staff building comprehensive material libraries automatically.
- Data Researchers collecting video metadata for analysis or reporting.
How It Works
- Send Search Request
- POST to the short-play API with ApiToken and Keyword to retrieve matching videos.
- Validate Response
- Confirm HTTP 200 status and parse JSON to extract video data and success flag.
- Check Parsing Success
- Stop workflow if parsing fails; proceed only if data is valid.
- Extract and Combine Fields
- Loop through video list to extract time, title, and URL, then combine into rows matching sheet columns.
- Write to Google Sheets
- Append or update rows in the specified spreadsheet and sheet, automating record storage.
What You'll Need
Before using this template, make sure you have:
- An API token for the short-play service to authenticate search requests.
- Google Sheets OAuth credentials authorized to write data into your target spreadsheet.
- A Google Sheets spreadsheet set up with a worksheet named and headers ordered as: time, title, url.
- The Spreadsheet ID extracted from your Google Sheets URL.
How to Use
- Step 1. Prepare Spreadsheet
- Step 2. Configure Credentials
- Step 3. Input Parameters
- Step 4. Run Workflow
- Step 5. Verify Results
Create a worksheet in your Google Sheet with columns: time, title, url.
Set up Google Sheets OAuth credentials for write access and obtain your short-play API token.
Fill in ApiToken, Keyword for search, SpreadsheetId, and SheetName in the workflow inputs.
Execute the workflow to fetch, parse, and append short drama data automatically.
Check your Google Sheet to confirm the new entries are correctly logged with time, title, and URL.
FAQs
What happens if the API response is not successful?
The workflow halts after checking the parsing success flag to prevent invalid data processing.
How does the workflow ensure data matches my spreadsheet columns?
It extracts time, title, and URL fields and combines them in the exact order your sheet headers require before appending.
Can I use this template for multiple keywords?
Yes, just update the Keyword parameter and rerun to fetch and log new search results accordingly.
What credentials are needed to write to Google Sheets?
Google Sheets OAuth credentials authorized to append or update rows in your target spreadsheet are required.
