Cronjob Gravityforms Plugin - Synchronize GF database with Google Spreadsheets

$250-750 USD

Completed

Posted

over 10 years ago

$250-750 USD

Paid on delivery

The plugin should sync the database of certain GF forms with a google spreadsheet. Even if the an entry gets updated by gravityforms the plugin should recognize update and updates google spreadsheet row as well. Different use cases: first use case: Entry gets saved into GF database with paymentstatus=processing --> plugin writes new row (lets say row number 421) into spreadsheet with all data of GF entry ---> 48 hours later the paymenstatus changes from "processing" to "approved" --> plugin recognizes changes and updates row 421 in google spreadsheet second use case: Entry gets saved into GF database --> plugin writes new row (lets say row number 422) into spreadsheet with all data of GF entry ---> 72 hours later the entry gets an additional note (typed in by hand in wordpress backend) --> plugin recognizes changes and updates(adds note) in row 422 in google spreadsheet

Google App Engine

JavaScript

PHP

Software Architecture

WordPress

Project ID: 5376051

About the project

9 proposals

Remote project

Active 10 yrs ago

Looking to make some money?

Email address

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

Awarded to:

@helmot

I have +10 years of experience in Python programming. What I know from gravity forms is that you have 2 tables in your wordpress database related to gravity forms. wp_rg_lead and wp_rg_lead_detail. wp_rg_lead holds one record for each entry. It has basic entry data such as id, date created, status, etc..., but it doesn't hold the actual field values. Those are stored in the wp_rg_lead_detail table. One record will be created for each field in your form. I will use a python script that would be run on your vps to read data from second table and compare with older version of data to extract changes and write in google spread sheet document. Also, I will use gspread [login to view URL] to connect to google spread sheet and make edits in that. Please let me know if you have any question here.

$350 USD in 7 days

4.8

(182 reviews)

8.1

9 freelancers are bidding on average $548 USD for this job

@workon

Question: If an entry has been delete we will also delete that row ? If new field has been added to the from, and new information columns appears for new records, we will update it as well ? The information on the GS will be create at the same order form fields has been created, or there a customization option required which defines which data will be ported, and which not ? Do you want to define the update interval or we set it for the best practice ? Looking forward to your reply.

$550 USD in 10 days

5.0

(224 reviews)

7.3

@ranganathp

Can help... I am an Expert... Please start a Discussion with me and we can get started from there... Please check the past projects I have handled and check my reviews for what employers have to say about my work... Can start right now...

$1,000 USD in 7 days

5.0

(88 reviews)

7.0

@icq

in the first use case after 48hrs payment status will be updated as approved by automaticaly or manualy done from admin interface?

$277 USD in 3 days

5.0

(104 reviews)

5.9

@VRWebSolutions

A proposal has not yet been provided

$618 USD in 12 days

4.7

(10 reviews)

5.0

@hitesh1002

A proposal has not yet been provided

$555 USD in 10 days

0.0

(0 reviews)

0.0

@ultimatedevelop

Greetings, my name is Michael Owen. I am new to working on freelancer but not new to the development world. I have just over 13 years experience in web development and have had a primary focus on WordPress solutions since 2006. I am currently ranked in the top 1% of all WP developers on Elance. I will be happy to share a link to my portfolio on that site, upon request. I have developed some of the most complex solutions for WP and would love to add your project into my portfolio. Over the years I have worked with countless api's including many of the different api's that are available via google. Thank you for your consideration in helping me to get established here on freelancer.com. Also, I provide an additional 90 days of post development support at no additional charge to you, I provide this support even if the project costs $5, this allows you plenty of time to work with the solution and find any bugs in the development and have me correct them for you. Best Regards, Michael

$500 USD in 10 days