See llms.txt for all machine-readable content.

Back to Templates

Log new FMCSA trucking carriers daily with Apify and Google Sheets

Quick overview

For freight brokers, trucking insurance agents, factoring companies and others selling to new trucking companies, this workflow fetches newly added FMCSA carriers daily using Apify and appends their details to Google Sheets.

How it works

  1. Runs every day at 07:00 using a schedule trigger.
  2. Calls the dedicated_crest/fmcsa-trucking-carrier-leads Apify actor, which uses official FMCSA data and can return USDOT and MC numbers, company names, states, fleet size, phone, email and authority status. The default input filters for Texas carriers added after yesterday, requires a phone number and limits results to 500.
  3. Appends the returned DOT and MC numbers, names, contact details, location, power units, drivers, added date and SAFER URL to Google Sheets. Authority status is available from the actor but is not mapped to the sheet by default.

Setup

  1. Create an Apify API token and add it as an HTTP Header Auth credential using Authorization: Bearer <token>. The actor is at https://apify.com/dedicated_crest/fmcsa-trucking-carrier-leads.
  2. Edit the HTTP request JSON input to choose states and, if desired, minPowerUnits and maxPowerUnits for fleet size. Adjust the phone requirement and maximum results to suit your needs.
  3. Connect your Google Sheets OAuth2 credential, replace YOUR_SHEET_ID with the target spreadsheet ID, and ensure Sheet1 has matching headers for the mapped fields. Activate the workflow when ready.

Requirements

  • Apify account
  • Google Sheets credential

Additional info

The actor charges $2 per 1,000 leads on Apify. n8n and Google Sheets costs are as usual.