Freshserver Projects Sync to Smartsheet

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.

---
來源：Freelancer.com | 出價次數：80 | 剩餘時間：6 日 | 專案類型：固定預算