Fix Lightspeed Kounta OAuth Connection in Google Apps Script — 90% Done, One Fix Needed

Posted 2 weeks ago

Worldwide

Summary

Fix Lightspeed Kounta OAuth Connection in Google Apps Script — 90% Done, One Fix Needed WHAT'S ALREADY BUILT I have a working Google Apps Script project (owned by my Google account) that connects to Tanda and Xero successfully. The project includes: OAuth2 library already installed All sheet tabs created (Dashboard, Daily, Weekly, Monthly, COGS_Tracker, RAW_Sales, RAW_Wages, RAW_COGS, Targets, Email_Log) Kounta config already structured in Code.gs with KOUNTA_CLIENT_ID, KOUNTA_CLIENT_SECRET, and KOUNTA_COMPANY_ID Lightspeed developer app already registered with Client ID: EkHz7V9KpiyHO8hU THE ONLY THING LEFT The Lightspeed Kounta OAuth connection is not completing. Kounta's authorization code expires in under 5 seconds — the token exchange must be handled instantly and automatically server-side. Manual copy-paste flows do not work. Lightspeed support confirmed: "the response actually needs to be near instant; it was designed with automation in mind." WHAT I NEED The connection completes automatically when I click Allow on the Kounta authorization page The access token is stored securely in Script Properties Sales data begins pulling from the Kounta API into the RAW_Sales sheet Access via Google share only — no credentials shared. PLEASE ONLY APPLY IF You have worked with Google Apps Script OAuth2 flows before You can explain in your proposal exactly how you would handle the sub-5-second token exchange requirement Applications that do not address the token expiry issue will not be considered.

  • $60.00

    Fixed-price
  • Expert
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
API
Google Apps Script
Activity on this job
  • Proposals:15 to 20
  • Last viewed by client:2 weeks ago
  • Hires:
    2
  • Interviewing:
    1
  • Invites sent:
    0
  • Unanswered invites:
    0
About the client
Member since May 12, 2025
  • AUS
    Burleigh Heads12:55 AM
  • $3.7K total spent
    7 hires, 2 active
  • 82 hours
  • Mid-sized company (10-99 people)

Explore similar jobs on Upwork

Zoho Creator
Microsoft Excel
Microsoft Access
Flowchart
Mail Merge
Automation
Interactive Data Visualization
Data Analysis
Fillable Form
Excel Formula
Excel Macros
Conversion to Editable File
Microsoft Word
Spreadsheet Skills
Visual Basic for Applications
Google Sheets

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers earned on Upwork in 2020

Find the best freelance jobs

Growing your career is as easy as creating a free profile and finding work like this that fits your skills.

Trusted by

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo