Empire Sync

A Ruby on Rails application that syncs Empire Flippers marketplace listings to HubSpot CRM deals and Google Sheets automatically once per day.

What it does

1. Fetches all "For Sale" listings from the Empire Flippers Public API — with full pagination support
2. Stores listing data in a PostgreSQL database
3. Creates a corresponding Deal in HubSpot CRM for each listing
4. Exports all listings to a Google Sheet (clears and rewrites daily)
5. Runs automatically once per day via Sidekiq background job scheduler
6. Prevents duplicate listings and duplicate HubSpot deals

Tech Stack

• Ruby on Rails 7.1
• PostgreSQL — database
• Sidekiq — background job processing
• sidekiq-scheduler — daily cron scheduling
• HTTParty — HTTP requests to Empire Flippers API
• hubspot-api-client — official HubSpot Ruby gem
• google-apis-sheets_v4 — Google Sheets API
• RSpec — test suite

Setup

Prerequisites

• Ruby 3.1+
• PostgreSQL
• Redis (required for Sidekiq)

Installation

git clone https://github.com/imlakshay08/empire-sync
cd empire-sync
bundle install

Environment Variables

Create a .env file in the root directory:

HUBSPOT_ACCESS_TOKEN=your_hubspot_private_app_token
GOOGLE_SHEETS_CREDENTIALS_PATH=config/google_credentials.json
GOOGLE_SHEET_ID=your_google_sheet_id

Also add your Google service account credentials file at config/google_credentials.json (never commit this file).

Database Setup

rails db:create
rails db:migrate

Run Tests

bundle exec rspec

Run the sync manually

rails console
ListingSyncService.sync

Run Sidekiq (background jobs)

bundle exec sidekiq

Architecture

SyncListingsJob (runs daily at midnight)
    ↓
ListingSyncService
    ├── EmpireFlippersService  →  fetches all listings from EF API (paginated)
    ├── HubspotService         →  creates deals in HubSpot CRM
    └── GoogleSheetsService    →  exports listings to Google Sheet

HubSpot Deal Fields

Deal Field	Source
Deal Name	"Listing ##{listing_number}"
Amount	listing_price
Close Date	30 days from sync date
Description	summary

Google Sheet Columns

Column	Source
Listing #	listing_number
Listing Price	listing_price
Summary	summary

Tests

16 RSpec tests covering:

• Listing model validations
• EmpireFlippersService API fetching with pagination
• ListingSyncService sync logic and duplicate prevention
• HubspotService deal creation
• GoogleSheetsService sheet creation and data export
• SyncListingsJob execution