Gravity Form to Google Sheet

susiethomas
(@susiethomas)

9 years, 7 months ago

I read the topic with the same Title, but it seemed to answer a question about Google Forms, instead of Gravity Forms to Google Sheets.

I apologize, but I am a bit of a novice. No idea where to begin. It looks like the Gravity Form data is being pulling correctly based on the debug report. From there, I am not sure. Debug Report below.

Thanks for the help!

*** Service ***
Array
(
[name] => Gravity to Google Evictions
[url] => https://script.google.com/macros/s/AKfycbxjCPWCT2IU3WMDxg-iNK0jiTdpmwoULs2kwm4c_rUSfEn53P4a/exec
[forms] => Array
(
[0] => gf_2
)

[success] =>
[failure] =>
[timeout] => 10
[mapping] => Array
(
[0] => Array
(
[lbl] =>
[src] => Case No.
[3rd] => Case No.
)

[1] => Array
(
[lbl] =>
[src] => Email
[3rd] => Client Email Address
)

[2] => Array
(
[lbl] =>
[src] => Management Company
[3rd] => Management Company
)

[3] => Array
(
[lbl] =>
[src] => Owner Name
[3rd] => Owner Name
)

[4] => Array
(
[lbl] =>
[src] => Property County
[3rd] => Property County
)

[5] => Array
(
[lbl] =>
[src] => Property Address (Street Address)
[3rd] => Street Address
)

[6] => Array
(
[lbl] =>
[src] => Property Address (City)
[3rd] => City
)

[7] => Array
(
[val] => 1
[lbl] =>
[src] => Georgia
[3rd] => State
)

[8] => Array
(
[lbl] =>
[src] => Property Address (ZIP / Postal Code)
[3rd] => ZIP / Postal Code
)

[9] => Array
(
[lbl] =>
[src] => Tenant Name 1 (First)
[3rd] => Tenant FName 1
)

[10] => Array
(
[lbl] =>
[src] => Tenant Name 1 (Last)
[3rd] => Tenant LName 1
)

[11] => Array
(
[lbl] =>
[src] => Tenant Name 2 (First)
[3rd] => Tenant FName 2
)

[12] => Array
(
[lbl] =>
[src] => Tenant Name 2 (Last)
[3rd] => Tenant LName 2
)

[13] => Array
(
[lbl] =>
[src] => Monthly Rent
[3rd] => Monthly Rent
)

[14] => Array
(
[lbl] =>
[src] => Past Due Rent
[3rd] => Past Due Rent
)

[15] => Array
(
[lbl] =>
[src] => Late Fees Due
[3rd] => Late Fees Due
)

[16] => Array
(
[lbl] =>
[src] => Utilities (Water, Cable, Gas, etc.)
[3rd] => Utilities (Water, Cable, Gas, etc.)
)

[17] => Array
(
[lbl] =>
[src] => Total Due (Price)
[3rd] => Price
)

[18] => Array
(
[lbl] =>
[src] => Demand Letter Date (Notice to Pay or Quit)
[3rd] => Demand Letter Date
)

)

)

*** Post (Form) ***
http://susanthomaslaw.com/eviction-referrals/
Array
(
[input_33] => 12d4562
[input_8] => [email protected]
[input_34] => Susan Thomas, Attorney at Law
[input_28] => Susan
[input_4] => DeKalb
[input_2_1] => 3333 Piedmont Rd NE, Suite 2050
[input_2_2] =>
[input_2_3] => Atlanta
[input_2_4] => Georgia
[input_2_5] => 30002
[input_2_6] => United States
[input_6_3] => hello1
[input_6_6] => hello2
[input_7_3] => hello3
[input_7_6] => hello4
[input_9] => $4,000.00
[input_10] => $4,000.00
[input_11] => $400.00
[input_12] => $150.00
[input_13_1] => Total Due
[input_13_2] => $4,550.00
[input_13_3] => 1
[input_17] =>
[MAX_FILE_SIZE] => 67108864
[input_21] => 11/09/2016
[input_20_1] => I have read and agreed to the Terms of Service.
[input_35] =>
[_gform_submit_nonce_2] => b6f279af82
[_wp_http_referer] => /eviction-referrals/
[is_submit_2] => 1
[gform_submit] => 2
[gform_unique_id] =>
[state_2] => WyJ7XCIxMy4xXCI6XCI1N2QzMTc4OGMzNGRmOWIwYmNiNGYyMGExNGI4ZjI3OVwiLFwiMTMuMlwiOlwiMDY1ZDc1MjMyMTFjM2FmOWNiNjRlMTQ2NDU3ZjVkMWJcIn0iLCIzOGI0NTMzMThjMTI5ZGU5MjFlZWFkM2YyYjBmYjdmYiJd
[gform_target_page_number_2] => 0
[gform_source_page_number_2] => 1
[gform_field_values] =>
[gform_uploaded_files] =>
[Case No.] => 12d4562
[Email] => Array
(
[0] => [email protected]
[1] =>
)

[Management Company] => Susan Thomas, Attorney at Law
[Owner Name] => Susan
[Property County] => DeKalb
[Property Address] => Array
(
[0] => 3333 Piedmont Rd NE, Suite 2050
[1] =>
[2] => Atlanta
[3] => Georgia
[4] => 30002
[5] => United States
)

[Tenant Name 1] => Array
(
[0] => hello1
[1] => hello2
)

[Tenant Name 2] => Array
(
[0] => hello3
[1] => hello4
)

[Monthly Rent] => $4,000.00
[Past Due Rent] => $4,000.00
[Late Fees Due] => $400.00
[Utilities (Water, Cable, Gas, etc.)] => $150.00
[Total Due] => Array
(
[0] => Total Due
[1] => $4,550.00
[2] => 1
)

[Comments] =>
[Demand Letter Date (Notice to Pay or Quit)] => 11/09/2016
[] => I have read and agreed to the Terms of Service.
)

*** Post (to Service) ***
Array
(
[timeout] => 10
[body] => Array
(
[Case No.] => 12d4562
[Client Email Address] => [email protected],
[Management Company] => Susan Thomas, Attorney at Law
[Owner Name] => Susan
[Property County] => DeKalb
[State] => Georgia
[Monthly Rent] => $4,000.00
[Past Due Rent] => $4,000.00
[Late Fees Due] => $400.00
[Utilities (Water, Cable, Gas, etc.)] => $150.00
[Demand Letter Date] => 11/09/2016
)

)

*** Response ***
WP_HTTP_Requests_Response Object
(
[response:protected] => Requests_Response Object
(
[body] => <!DOCTYPE html><html><head><link rel=”shortcut icon” href=”//ssl.gstatic.com/docs/script/images/favicon.ico”><title>Error</title><style type=”text/css”>body {background-color: #fff; margin: 0; padding: 0;}.errorMessage {font-family: Arial,sans-serif; font-size: 12pt; font-weight: bold; line-height: 150%; padding-top: 25px;}</style></head><body><div></div><center>Script function not found: doPost</center></body></html>
[raw] => HTTP/1.1 200 OK
Content-Type: text/html; charset=utf-8
Cache-Control: no-cache, no-store, max-age=0, must-revalidate
Pragma: no-cache
Expires: Mon, 01 Jan 1990 00:00:00 GMT
Date: Thu, 10 Nov 2016 01:09:55 GMT
Content-Encoding: gzip
P3P: CP=”This is not a P3P policy! See https://support.google.com/accounts/answer/151657?hl=en for more info.”
P3P: CP=”This is not a P3P policy! See https://support.google.com/accounts/answer/151657?hl=en for more info.”
X-Content-Type-Options: nosniff
X-Frame-Options: SAMEORIGIN
X-XSS-Protection: 1; mode=block
Server: GSE
Set-Cookie: NID=90=HLLGaKSEd-uy6B5QxakzJBOMbDAOAw-u6CL15AQdeRR95sTzWjS725CRcM_Eic3vtFjVcqD2rYlk_oy8Za3jknSAkYaj-uwgX_TvmnoCWxz_2GxoXGsdZ2X7Sd-kkKjD;Domain=.google.com;Path=/;Expires=Fri, 12-May-2017 01:09:55 GMT;HttpOnly
Set-Cookie: NID=90=EkGQm995h2HA17XB63Ll68-gSPFkB1DqlVS0bw7MPiapz9f5i8LihTXpvW0Sm43Ib5z-pRHzSV4jUgPkVDrhEdi_qrKi76zMFItnSdQ4H3BTJ6J23g_U4s80r52nz2iE;Domain=.google.com;Path=/;Expires=Fri, 12-May-2017 01:09:55 GMT;HttpOnly
Alt-Svc: quic=”:443″; ma=2592000; v=”36,35,34″
Connection: close
Transfer-Encoding: chunked

<!DOCTYPE html><html><head><link rel=”shortcut icon” href=”//ssl.gstatic.com/docs/script/images/favicon.ico”><title>Error</title><style type=”text/css”>body {background-color: #fff; margin: 0; padding: 0;}.errorMessage {font-family: Arial,sans-serif; font-size: 12pt; font-weight: bold; line-height: 150%; padding-top: 25px;}</style></head><body><div></div><center>Script function not found: doPost</center></body></html>
[headers] => Requests_Response_Headers Object
(
[data:protected] => Array
(
[content-type] => Array
(
[0] => text/html; charset=utf-8
)

[cache-control] => Array
(
[0] => no-cache, no-store, max-age=0, must-revalidate
)

[pragma] => Array
(
[0] => no-cache
)

[expires] => Array
(
[0] => Mon, 01 Jan 1990 00:00:00 GMT
)

[date] => Array
(
[0] => Thu, 10 Nov 2016 01:09:55 GMT
)

[content-encoding] => Array
(
[0] => gzip
)

[p3p] => Array
(
[0] => CP=”This is not a P3P policy! See https://support.google.com/accounts/answer/151657?hl=en for more info.”
[1] => CP=”This is not a P3P policy! See https://support.google.com/accounts/answer/151657?hl=en for more info.”
)

[x-content-type-options] => Array
(
[0] => nosniff
)

[x-frame-options] => Array
(
[0] => SAMEORIGIN
)

[x-xss-protection] => Array
(
[0] => 1; mode=block
)

[server] => Array
(
[0] => GSE
)

[set-cookie] => Array
(
[0] => NID=90=HLLGaKSEd-uy6B5QxakzJBOMbDAOAw-u6CL15AQdeRR95sTzWjS725CRcM_Eic3vtFjVcqD2rYlk_oy8Za3jknSAkYaj-uwgX_TvmnoCWxz_2GxoXGsdZ2X7Sd-kkKjD;Domain=.google.com;Path=/;Expires=Fri, 12-May-2017 01:09:55 GMT;HttpOnly
[1] => NID=90=EkGQm995h2HA17XB63Ll68-gSPFkB1DqlVS0bw7MPiapz9f5i8LihTXpvW0Sm43Ib5z-pRHzSV4jUgPkVDrhEdi_qrKi76zMFItnSdQ4H3BTJ6J23g_U4s80r52nz2iE;Domain=.google.com;Path=/;Expires=Fri, 12-May-2017 01:09:55 GMT;HttpOnly
)

[alt-svc] => Array
(
[0] => quic=”:443″; ma=2592000; v=”36,35,34″
)

)

)

[status_code] => 200
[protocol_version] => 1.1
[success] => 1
[redirects] => 0
[url] => https://script.google.com/macros/s/AKfycbxjCPWCT2IU3WMDxg-iNK0jiTdpmwoULs2kwm4c_rUSfEn53P4a/exec
[history] => Array
(
)

[cookies] => Requests_Cookie_Jar Object
(
[cookies:protected] => Array
(
[NID] => Requests_Cookie Object
(
[name] => NID
[value] => 90=EkGQm995h2HA17XB63Ll68-gSPFkB1DqlVS0bw7MPiapz9f5i8LihTXpvW0Sm43Ib5z-pRHzSV4jUgPkVDrhEdi_qrKi76zMFItnSdQ4H3BTJ6J23g_U4s80r52nz2iE
[attributes] => Requests_Utility_CaseInsensitiveDictionary Object
(
[data:protected] => Array
(
[domain] => google.com
[path] => /
[expires] => 1494551395
[httponly] => 1
)

)

[flags] => Array
(
[creation] => 1478740195
[last-access] => 1478740195
[persistent] =>
[host-only] =>
)

[reference_time] => 1478740195
)

)

)

)

[filename:protected] =>
[data] =>
[headers] =>
[status] =>
)