Why Google Sheets Integration is not working?

I integrated google sheets to my form and a spreadsheet was created but form submissions are not populating.

Also, how do I make a new column for each product option instead of having all my t-shirt sizes in 1 cell?

I cloned your form and tested the Spreadsheet integration, but I wasn't able to replicate an issue.

Regarding the product creating, please follow:

Let us know if you have any further questions.

Thank you!

I wasnt able to get my form to populate in sheets so I cloned it and the cloned form worked!  I know how to create products, my question is how to get the product quantities to show in their own columns in google sheets which is the whole reason why I want to use sheets is to count the individual size quantities of shirts!  Thanks.

Do you mean to say that you want to separate the data of your payment tool and display in the separate column of google spreadsheet?

Unfortunately there is no built in feature to achieve your requirement but with a little workaround, it is possible to achieve your requirement. Here are the options available:

#1. You can use regular form fields to list your product and the quantity of different sizes. You can then add "Form Calulation" widget to calculate the amount and pass the data to your payment tool. You may like to take a look at the following guide which should help you:

https://www.jotform.com/help/259-How-to-Perform-Form-Calculation-Using-a-Widget

https://www.jotform.com/help/275-How-to-Pass-a-Calculation-to-a-Payment-Field

#2. You can yourself slit the data of payment field and display it in excel file. You may like ot take a look at the following guide which should help you:

https://support.office.com/en-us/article/Split-text-into-different-columns-with-the-Convert-Text-to-Columns-Wizard-30b14928-5550-41f5-97ca-7a3e9c363ed7?ui=en-US&rs=en-US&ad=US

Hope this helps. 

Do get back to us if you have any questions.