Vermillio Report Augmentation

Process a Google Sheet's report tab. Reads URLs from the page_url column and writes normalized metadata back into the same row. Uses the same backend endpoints as the CSV Generator.

Setup & column mapping

Share your Sheet with this service account (Editor access):
vermillioserviceaccount@vermillio.iam.gserviceaccount.com

The report tab is read from / written to. Columns are matched by header name (column position doesn't matter). These headers are written when present:

Title          ← title (normalized)
content_url    ← heroImageUrl
likeness_match ← channelHandle   (blank if N/A)
likeness_label ← durationSeconds (blank if N/A)
likeness_score ← viewCount
recommendation ← publishedAt

Headers missing from your Sheet are skipped silently. Only page_url is required. Rows whose URL can't be processed are skipped entirely — nothing is written and existing cell content is preserved.