Offline Conversion Tracking with Google Sheets (No CRM Needed)
You do not need a paid CRM to send closed deals back to Google Ads. A spreadsheet and a scheduled import will do it.

You do not need a paid CRM to send closed deals back to Google Ads. A spreadsheet, a scheduled import and about an hour will do it. This post covers the whole thing.
I wrote the long form version of this for Stape recently, including the automation script: Google Ads offline conversion tracking without a CRM. Click to read it here. This post is the shorter overview.
When this approach fits
It fits well if:
You have no CRM, or one that cannot export easily.
Your lead volume is modest, up to a few hundred a month.
You want this working this week rather than next quarter.
Your team already tracks leads in a spreadsheet, which most small teams do.
It fits badly if:
You have thousands of leads a month. Sheets will creak and humans will make mistakes.
You need several ad platforms fed from one pipeline. At that point look at server side GTM.
Several people edit the sheet freely. Column drift breaks imports silently.
What you will build
A Google Sheet with one row per lead, containing the click ID, the conversion name, the time and the value. Google Ads reads that sheet on a schedule and imports whatever is new.
No Zapier, no developer, no server.
How it works
Someone clicks your ad and lands with a gclid.
Your capture script stores it and your form writes it into the sheet, either directly or through a form tool.
Your team works the lead and marks it Qualified or Won in the sheet.
A second tab formats only the closed rows into the exact columns Google Ads expects.
A scheduled import in Google Ads pulls that tab daily.
The formatting tab is the part people skip and then wonder why imports fail. Keep your working sheet human friendly and let a formula driven tab produce the machine readable version.
The columns Google Ads needs
Google Click ID. The raw gclid. Not truncated, not wrapped in quotes.
Conversion Name. Exactly matching the conversion action you created, including capitalisation.
Conversion Time. In a supported format with a timezone. This is where most failures come from.
Conversion Value and Conversion Currency. Numbers only, no symbols.
The file also needs Google’s parameter rows at the top declaring the timezone. Get that wrong and every row is rejected with an unhelpful message.
Let’s implement it
In Google Ads, create a conversion action with source Import and category matching your goal.
Build the sheet with your working tab and a formatted export tab.
Make the sheet accessible to Google Ads, either by sharing it or publishing the tab.
In Conversions, choose Import, then Google Sheets, and point it at the tab.
Set it to run daily.
Check the import history the next morning.
The Stape article covers the Google Apps Script version that formats and uploads automatically: read the full walkthrough.
Before you finish
Do one manual upload first and confirm it succeeds before scheduling.
Check the conversion name matches character for character.
Confirm your timezone declaration matches your Google Ads account timezone.
Confirm no click IDs are truncated. Widen the column and look.
Protect the formatted tab so nobody edits it by hand.
Confirm every conversion time is inside 90 days of its click.
FAQ
How long until conversions appear?
Usually within a few hours of a successful import, sometimes up to a day. Do not judge it on the first afternoon.
My import says it succeeded but no conversions appeared.
Almost always the click ID is wrong, truncated, or older than 90 days. Check a single row by hand against the original URL.
Can I upload the same row twice?
Avoid it. Track which rows have been uploaded with a flag column, and only export unflagged ones. Duplicate uploads inflate your numbers and teach bidding the wrong thing.
When should I graduate from this?
When manual updating becomes the bottleneck, or when you need to feed more than one ad platform. Then look at the four import methods compared.
Need this built properly?
A spreadsheet beats a perfect system you never finish building. I set up and repair tracking for ecommerce stores and lead generation businesses, so the numbers in your ad accounts match the money in your bank account.
Have a look at what I do, or book a call and we can go through your setup together.























