Find Jobs
Hire Freelancers

Sync Google Sheet with Smartsheets (zapier, workato, Microsoft Flow)

$15-25 USD / hour

Closed
Posted over 4 years ago

$15-25 USD / hour

I have a google sheet with a bunch of columns that look like this - [login to view URL] I need to be able to sync it to a Smartsheet. I need to be able to make changes in the google sheet or smartsheet and have those changes make an update to the other system. Ideally we would also be able to track modifications on the rows and include a new column called "last modified" where we would write the date of the last time something in the row changed. If it would make things easier we can add an ID column to both the google sheet and smart sheet. Please let us know which platform you would prefer to use for this, how much time you need, and or if you see any issues. Please note: generic proposals will be down voted and then deleted. We want to avoid spending a lot of time communicating with spam bidders.
Project ID: 23388982

About the project

10 proposals
Remote project
Active 4 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
10 freelancers are bidding on average $25 USD/hour for this job
User Avatar
Hi, We have got experience with Smartsheet as well as with Google sheet. We understood your requirement and would like to work on this project and help you build sync solution you need. We will be using app script, smartsheet sdk and PHP. Lets discuss and get started. Thank You, Ghanshyam - CWE
$25 USD in 40 days
5.0 (177 reviews)
8.2
8.2
User Avatar
Hi, Keen to work on this project. I am well versed with various kind of integration between multiple platforms. I have used platforms like Zapier and Integromat in the past for building these kind of integrations. Zapier has been used to build inegration between Excel and Kajabi. In another project Integromat has been used for integration between Google sheets, gmail, Twilio. Have also created Microsoft flows for few of my customers. I have good exposure to Smartsheet as I have used the software in the past. My preference for platform would have been Integromat unless you have already invested into Zapier, workato or Microsoft flow. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks
$25 USD in 10 days
4.9 (123 reviews)
5.8
5.8
User Avatar
Hello, I have experience with Google Sheets API and Smartsheet API. I understand that you would like to keep both files in sync. For that purpose, there should be third file (a master file) as well (preferably in Google Sheets) which will be used as a reference and all the updates will be broadcasted through this file. To keep things in sync, I will imitate the algorithms from multithreaded systems, (like atomic read writes). Tracking modifications can be achieved easily. I could make more detailed suggestions after hearing more about your workflow. As you can see I am very competent on the subject and I would like to convert this hourly job to one time fixed payment for 500$ and I can deliver this in 10 days. Please contact me to discuss the details and timeline.
$30 USD in 40 days
5.0 (8 reviews)
5.6
5.6
User Avatar
Hi. I am ready to write your project Write apps on your demand in many languages (Visual Basic, VBA, VBS, .NET, C#, JS, Python, Java, PowerShell) Write database apps including many db formats: MS Access, MS SQL, SQL Server, MySQL, SQLite, PostgreSQL, Firebird Write Automation apps including: * Automation Desktop apps. Some examples: Automation Playing Games, Automation Start/Stop/Click 3rd party apps * Automation Web apps. Some examples: Automation Web Scraping apps, Automation Web Crawling apps * Automation Data Processing apps: Automation formatting data to a specified template * Automation Data, Document Converting apps * Automation Macro, VBA for all apps in MS Office (Excel, Word, Outlook), OpenOffice, GoogleSheet * Automation Installers/Setups * Convert your Manual tasks to Automation solutions Write Web Service, Web API, Desktop API apps. Some examples: Google API, Bing API, Facebook API, MS API Fix/Solve any errors in your OS, apps
$20 USD in 40 days
4.9 (13 reviews)
4.1
4.1
User Avatar
Hello, Interested in the job. I am a Software Developer with expertise building automated workflows using the extensive ecosystem of services and APIs that make up Google's Cloud Platform. Creating a two-way sync between a Google Sheet and Smartsheet should be possible by integrating the two platforms via their respective REST APIs. Using an id column to map rows across the two services would be ideal. If awarded the project I'd need you to create and/or grant access to a dedicated Google account to effectively leverage Google's Cloud Platform to deploy the solution I have in mind. If you're interested in my approach lets open a dialogue to discuss the project in depth. Thank you for taking the time to read my proposal. I look forward to your response. Regards, Damion Murray DimuDesigns
$45 USD in 25 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I will compelte the project as per your Choice Relevant Skills and Experience I have good experience in automation anywhere for automating the processs
$22 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have more than 15 years of experience in programming in C, C#, Java, etc, I will be able you to deliver you a solution which will fulfill you requirements of keeping various sheets in sync. The number of sheets to be kept in sync will not matter. The solution will use proper locking mechanisms to ensure that the updates from the sync are delivered without overlapping with other updates.
$25 USD in 40 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Austin, United States
4.9
463
Payment method verified
Member since May 9, 2004

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.