Adding data from Kartra forms to Google Sheets

[JenniDFA]

Hi,

I'm trying to add data from Kartra forms to Google Sheets. It appears that you can only add the data from Kartra forms to one spreadsheet.

I have over 100 Kartra forms and I want to be able to add the data from each form to a separate google sheet.

Does anyone have any ideas?

Thanks in advance.

 

[Pabblymember11]

Hey @JenniDFA

If you are getting data from all the forms of your Katra then you can use the Router action step where you can define individual routes to send the data into separate Google Sheets.

You can also refer to the following video tutorial on using the Router action in your workflow.

 

[JenniDFA]

Hi @Supreme,

This is fantastic! Thank you so much for you message!

It works fine when I do the 'tests', however, it isn't working when I try it in reality...I don't know if it's something to do with this - it's not pulling through the 'webhook response', and I'm not sure why?

Thanks so much for your help!

View attachment 15958

 

[Pabblymember11]

Hi @Supreme,

This is fantastic! Thank you so much for you message!

It works fine when I do the 'tests', however, it isn't working when I try it in reality...I don't know if it's something to do with this - it's not pulling through the 'webhook response', and I'm not sure why?

Thanks so much for your help!

View attachment 15958

Please try recapturing the webhook response once and then try again.

 

[JenniDFA]

Yes I have tried that but it's not working. I've tried setting it back up again from scratch as well...

 

[Pabblymember11]

Yes I have tried that but it's not working. I've tried setting it back up again from scratch as well...

Kindly refer to the following video tutorial and try again capturing the webhook response.

Let us know if that helps you out.

 

[JenniDFA]

I've managed to get it all working now! Thank you so much! I'm super happy.

The only thing I need to tweak now is the date format and time...

I would like the date format to be DD-MM-YY as opposed to YYYY-MM-DD - is that possible? If yes, how do I do it?

Also, the time zone seems to be out...how do I make it so the correct time is coming through?

Thanks for everything! You're amazing!

 

[JenniDFA]

Oh and one final thing; I need to delete the test data from the Google Sheets. How do I safely do that without messing up the workflow?

Thanks.

 

[Pabblymember11]

I would like the date format to be DD-MM-YY as opposed to YYYY-MM-DD - is that possible? If yes, how do I do it?

Also, the time zone seems to be out...how do I make it so the correct time is coming through?

You can use Date/Time Formatter by Pabbly : Format Date with Time Zone action step to change the timezone and the format accordingly.

Please try the following screenshot and let us know.

 

[JenniDFA]

Thanks.

How do I know what the current timezone is set to (for me to enter into the 'From Format' box)?

 

[Pabblymember11]

Thanks.

How do I know what the current timezone is set to (for me to enter into the 'From Format' box)?

You can try the UTC timezone in the From TimeZone field to convert the time zone since most of the applications send the data in UTC time format.

 

[JenniDFA]

That's not working...there are quite a lot of variables to get right, so it's hard to know which is the issue. I don't think the time zone is right - UTC is an hour difference to us, but the time being pulled through is 4 hours difference.

I've tried doing it in both of these places with no luck:

 

[Pabblymember11]

That's not working...there are quite a lot of variables to get right, so it's hard to know which is the issue. I don't think the time zone is right - UTC is an hour difference to us, but the time being pulled through is 4 hours difference.

I've tried doing it in both of these places with no luck:

View attachment 16239


View attachment 16240

You can also try the "Date Time Formatter: Add/Subtract Time" action step to change the time difference accordingly if you already know the time change.
Perhaps, that might help you out. Kindly try this at your end and let us know if that works for you.

 

[JenniDFA]

That won't help, because I also need to change the format of the date...

 

[Pabblymember11]

That won't help, because I also need to change the format of the date...

Indeed, you can change the format of the date too by selecting the desired format in the To Format.

 

[JenniDFA]

But I couldn't get that to work...(see my earlier post)...

 

[Pabblymember11]

Hey @JenniDFA

Please check the following action step and fill the time difference accordingly and try again.

 

[JenniDFA]

Nope, that's still not working...

 

[JenniDFA]

I'm not sure I'm even putting the Date/Time formatter in the correct place....does it need to go before or after the 'add to google sheets' action?

 

[JenniDFA]

Also, 'adding 4 hours' won't work when we change time, so we need to figure out a way of knowing what the timezone is that my Pabbly is set to...