Model. Creator. Lawyer. Builder.

TikTok Shop order and affiliate exports are normalized and deduplicated, then mapped to the video that drove each sale. Commission, cancellations, returns and payout timing land in one Google Sheet with history. Every Monday, Claude writes a plain-Spanish report: what moved, what stalled, what to film next.

Input

TikTok Shop order + affiliate exports (CSV)

Output

Live Google Sheet, weekly written report, alert on cancellations

• Sheets
• Apps Script
• Claude

For Creators · Agencies

A weekly scan of trending TikTok Shop products in Mexico, scored on commission, sales velocity, price band and creator saturation. Each candidate comes with a one-line "why now" and a suggested angle. Output is a ranked shortlist, not a list of everything.

Input

Trend and category exports, your niche and price range

Output

Ranked shortlist with angle and commission, every week

• Sheets
• Claude

For Creators

The calendar is generated from the sales dashboard and the product radar, not from a blank page: seven days of hooks, three-line scripts, on-screen text, hashtags and posting windows. Each week is versioned, so you can see what you planned, what you filmed and what sold.

Input

Dashboard + radar data, your brand voice sheet

Output

7-day calendar in Sheets, exportable to Notion or your phone

• Sheets
• Claude

For Creators · Agencies

Paste a product link or a brand brief. Claude extracts claims, specs and objections, then writes a review script with hook variants, a shot list, B-roll and on-screen text, plus three CTA versions that respect TikTok Shop's claim rules. Mexican Spanish or English, your tone.

Input

Product URL or PDF brief

Output

Script, shot list, CTA variants, ready to film

• Claude

For Creators · Brands

Finished cuts are transcribed, captioned in Spanish and subtitled in English, then exported as SRT and burned-in versions sized for TikTok, Reels and Shorts. Brand names and product terms come from a glossary so they are spelled the same in every video.

Input

Folder of finished videos

Output

SRT files, burned-in versions per platform, caption copy

• Python
• Claude

For Creators · Brands

Videos, captions and hashtags are pushed through TikTok's Content Posting API into your draft inbox, with a log of what went where. Nothing is published automatically: you open the draft, check it and post. Built for the days you film ten videos and want to stop copy-pasting.

Input

Video files + caption sheet

Output

Drafts in your TikTok inbox, upload log

• TikTok API
• Python

For Creators · Agencies

Product order, talking points per product, timers, pinned-comment copy and answers to the usual questions, all on one page before you go live. Afterwards the sales export is matched to the stream timeline, so you see which minute sold. Built from the lives Andrea hosts for beauty brands herself.

Input

Product list for the live, past live exports

Output

Run-of-show page, post-live sales recap

• Sheets
• Claude

For Creators · Brands

Comments and messages are classified into questions, objections, requests and praise. Questions become an FAQ and reply templates; objections become video ideas that answer them; requests become products for the radar. Runs weekly, in Spanish, with the originals linked.

Input

Comment and DM exports

Output

FAQ, reply templates, video ideas with source comments

• Claude
• Sheets

For Creators · Brands

A brand's brief, in any format, is parsed into deliverables, formats, deadlines, usage rights, exclusivity windows and approval rounds. The result is a shared tracker both sides work from, and a checklist of what is missing before you commit.

Input

Brief as PDF, email or deck

Output

Deliverables tracker, open-questions list, timeline

• Claude
• Sheets

For Creators · Brands · Agencies

Collaboration contracts are summarized clause by clause: usage rights, territories, duration, exclusivity, payment terms, penalties and anything unusual, flagged in Spanish and English. Reviewed by a practicing lawyer who reads these for a living. The automation prepares the review; Andrea signs off on it.

Input

Contract PDF

Output

Clause summary, flag list, questions to ask

• Claude

For Creators · Models

A bilingual intake form feeds Claude the client's situation: nationality, purpose, income, family, timeline. It returns the likely visa route, the document checklist for that route, the open questions a lawyer still has to ask, and a draft reply in the client's language. The lawyer reviews and sends. Planned first for Maldonado Abogados; the same frame fits any firm or consultancy that qualifies leads by hand.

Input

Intake form or forwarded email

Output

Route memo, document checklist, open questions, draft reply

• Claude
• Google Forms
• Apps Script
• Gmail drafts

For Law firms · Consultancies

A web and PDF media kit that pulls its numbers from your own exports, updated when new exports are supplied. Target brands are researched and ranked, pitch emails are personalized from your past content, and a follow-up tracker tells you who to nudge this week.

Input

Your exports, a list of categories you want to work in

Output

Live media kit, ranked brand list, pitch drafts, follow-up tracker

• Cloudflare
• Claude
• Sheets

For Creators · Models

Bespoke builds for creators, agencies and brands: approval portals where a brand signs off videos, asset libraries with search, intake forms that write the brief for you, internal dashboards. Scoped small, built on Claude, Python and Apps Script, documented so your team can run it without Andrea.

Input

A repeating process and the files it touches

Output

A working tool, documentation, a handover session

• Claude
• Python
• Apps Script
• Cloudflare

For Agencies · Brands