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

  1. Someone clicks your ad and lands with a gclid.

  2. Your capture script stores it and your form writes it into the sheet, either directly or through a form tool.

  3. Your team works the lead and marks it Qualified or Won in the sheet.

  4. A second tab formats only the closed rows into the exact columns Google Ads expects.

  5. 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

  1. In Google Ads, create a conversion action with source Import and category matching your goal.

  2. Build the sheet with your working tab and a formatted export tab.

  3. Make the sheet accessible to Google Ads, either by sharing it or publishing the tab.

  4. In Conversions, choose Import, then Google Sheets, and point it at the tab.

  5. Set it to run daily.

  6. 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.

Need accurate tracking?

Its Free

500+ Happy Clients ⭐️

Keep Reading

See exactly where you’re wasting ad spend and how better tracking can double your sales.

See exactly where you’re wasting ad spend and how better tracking can double your sales.

Tracking in 3 Hours

Tracking in 3 Hours

I Manage Everything

I Manage Everything

24/7 Expert Support

24/7 Expert Support

TESTIMONIALS

Trusted by 500+ satisfied clients

Discover how we’ve driven growth and innovation.

500+ Tracking

500+ Tracking

Adélaïde De Vos

3,922 followers

I had the pleasure to work with Abdul and I can say that he exceeded my expectations. He was professional, patient, and clear in his explanations and committed to client satisfaction. If you're looking for someone who is not only highly skilled but also reliable and committed to client satisfaction, I highly recommend Kayium!

Dean Watson

1,030 followers

Kayium setup our tracking for Google Ads and Meta Ads, which helped us get 20%+ more conversions on the same ad spend. He didn’t just handle the technical setup,he also took the time to explain why it works and how it improves results. If you’re looking for someone skilled, reliable, and committed to delivering real results, I highly recommend him!

David Friend

CEO: Profitable Sites

Kayium set up accurate tracking that helped us scale ads fast and boost conversions by over 25%. He gave us clear insight into which ads drive revenue.

Lalita Sundari

7,924 followers

I've worked with Kayium; his strategic mindset and expertise in GTM, GA4, Pixel & Server Side Tracking, are invaluable! I highly recommend Kayium!

© 2026 Abdul Kayium

Owned by Kayium

© 2026 Abdul Kayium

Owned by Kayium