How it works

1. Google Sheets checks for new rows on a schedule. 2. For each new row, an HTTP request asks the TikTok data API for the creator's profile. 3. A second HTTP request asks for the transcript of the video link in the row. 4. Gmail sends you an email with the profile data and the transcript. 5. Add your API key to both HTTP steps and pick the spreadsheet, sheet and recipient when you install the template.