GOOGLE SHEET + MYSQL HEELP

[othonrighetti]

Hello everyone, I would like my GOOGLE SHEET WORKSHEET to get all information from within a given MYSQL table, then if I insert information or update some information in the GOOGLE SHEET TABLE, it would send it back to MYSQL.

Can someone help me?

 

[Pabblymember11]

Hey @othonrighetti

Regarding your concern, you can pick the MYSQL trigger event which will get your live data from your MYSQL table, and then by mapping the fields in the "Google Sheets: Add New Row" action event, you can add the data to your Google Sheets.

Later you can pick the "MySQL: Insert Row" action event to add the data to your MYSQL table. Kindly try creating the workflow at your end and let us know if that works for you.

 

[Felipe]

even using corrects credentials... the waring keeps showing... how can I solve that?

 

[Felipe]

Does this webhook works with automatically insert data? for example.. the data will be fillet from wordpress forms and automaticaly insert on google sheets, should work to get rows? or just manually input on google sheet?

 

[Pabblymember11]

Hey @Felipe

Kindly try to make Pabbly Connect IP address( 44.224.102.169 ) a whitelist and then try reconnecting the MYSQL action step.