Freshserver Projects Sync to Smartsheet
Budget / Salary$30–250
TypeFreelance project
LocationRemote
Posted2 hours ago
1. Smartsheet
2. A Google Spreadsheet
Scope of the sync
• Custom fields: every text field that exists in Fresh server must move over with no omissions.
• Custom objects: only the Projects object is in scope right now.
For Smartsheet I want the script to create (or update) rows so that each Project is represented and its text-based custom fields remain continuously up to date. The same information should land in a Google Sheet in real time or as close to real time as practical.
Technical expectations
• Code against the official Freshserver and Smartsheet REST APIs, using JSON payloads throughout.
• Handle authentication securely (OAuth or token as appropriate).
• Write clear, commented code so I can maintain it later.
• A short README that shows how to deploy and schedule the job on my server.
Experience
Please respond only if you have at least two years of hands-on work with JSON-driven API integrations and can name previous projects involving Smartsheet or Google Sheets.
When the job is done, I will test by adding and editing Projects in Freshserver; the changes must appear in both Smartsheet and my Google Spreadsheet without manual intervention.
2. A Google Spreadsheet
Scope of the sync
• Custom fields: every text field that exists in Fresh server must move over with no omissions.
• Custom objects: only the Projects object is in scope right now.
For Smartsheet I want the script to create (or update) rows so that each Project is represented and its text-based custom fields remain continuously up to date. The same information should land in a Google Sheet in real time or as close to real time as practical.
Technical expectations
• Code against the official Freshserver and Smartsheet REST APIs, using JSON payloads throughout.
• Handle authentication securely (OAuth or token as appropriate).
• Write clear, commented code so I can maintain it later.
• A short README that shows how to deploy and schedule the job on my server.
Experience
Please respond only if you have at least two years of hands-on work with JSON-driven API integrations and can name previous projects involving Smartsheet or Google Sheets.
When the job is done, I will test by adding and editing Projects in Freshserver; the changes must appear in both Smartsheet and my Google Spreadsheet without manual intervention.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.