Step 2: Connect External API Call

Configure the Twitter API search request that fetches tip-related tweets.

1. Open External API Call and set URL to https://api.twitterapi.io/twitter/tweet/advanced_search.
2. Enable Send Query and set Authentication to genericCredentialType with Generic Auth Type set to httpHeaderAuth.
3. Add query parameters: query = (#bugbountytips OR #bugbounty OR #bugbountytip) -Writeups -discount -phishing -fuck and queryType = Latest.
4. Credential Required: Connect your httpHeaderAuth credentials.

Step 3: Set Up Transform Script

Normalize the API response so each tweet becomes a consistent item with formatted fields.

1. Add the Transform Script node after External API Call.
2. Paste the provided JavaScript into Code to handle single tweets or tweet arrays and format createdAt.
3. Verify the node returns fields like tweetId, url, content, and createdAt.

Step 4: Configure Update Sheet Row

Append or update rows in Google Sheets with the transformed tweet data.

1. Add Update Sheet Row and connect it to Transform Script.
2. Set Operation to appendOrUpdate.
3. Select your spreadsheet in Document and choose Sheet = Sheet1 (gid 0).
4. Map columns using expressions:
   • Url = {{ $json.url }}
   • Content = {{ $json.content }}
   • TweetID = {{ $json.tweetId }}
   • Created At = {{ $json.createdAt }}
   • Date = {{ (() => { const raw = $json.createdAt; // e.g. "July 7, 2025 at 04:43 AM" const [monthStr, day, yearTime, , time, meridian] = raw.split(/[\s,]+/); const months = { January: "01", February: "02", March: "03", April: "04", May: "05", June: "06", July: "07", August: "08", September: "09", October: "10", November: "11", December: "12" }; const [hour, minute] = time.split(":").map(Number); let hh = meridian === "PM" && hour !== 12 ? hour + 12 : (meridian === "AM" && hour === 12 ? 0 : hour); const formattedHour = String(hh).padStart(2, '0'); return `${yearTime}-${months[monthStr]}-${String(day).padStart(2, '0')} ${formattedHour}:${minute}:00`; })() }}
5. Set Matching Columns to TweetID to prevent duplicates.
6. Credential Required: Connect your googleSheetsOAuth2Api credentials.

Step 5: Test and Activate Your Workflow

Validate the end-to-end flow from trigger to Google Sheets updates.

1. Click Execute Workflow to run a manual test.
2. Confirm External API Call returns tweet data and Transform Script outputs items with tweetId and createdAt.
3. Verify Update Sheet Row appends or updates rows in your sheet with the mapped values.
4. Turn the workflow Active to enable scheduled runs every 4 hours.