I have 2 forms that are both integrated with Google Sheets.  I've set up a webhook to pull form 1 data from Google Sheets to prefill data in Form 2.

The issue I have is that the forms name fields are First Name & Last Name but the Google sheets integration concatenates First Name and Last Name into one field (Name).  When I run the webhook it returns Name (First Name & Last Name concatenated) but form 2 has separate First Name & Last Name fields and I cannot split the string returned when mapping the fields in form 2 so both name fields are populated correctly with First Name & Last Name in form 2.