Unable to write data by apk

Vinod_Menariya · April 18, 2021, 12:24pm

I have done everything but I'm unable to update data in google sheet can anyone pls help .

My script also working fine when I'm running in browser it's inserting data in sheet..

Pls help ?

TIMAI2 · April 18, 2021, 2:18pm

You don't show your script.....

If you can do it in your browser then you must have a doGet(e) function in your script ?

Why not use Web1.Get in your blocks ?

If using doPost(e) in your script, you will need to remove the ? in front of ID in your blocks.

Vinod_Menariya · April 18, 2021, 3:24pm

Hi
Thanks for your response !
Now I'm stuck on this error pls suggest on this .

TIMAI2 · April 18, 2021, 3:26pm

The reason for your error will be at the end of the response, you do not show this.
Have you created a new version of your web app since making any changes?
You still do not show your web app script?

Vinod_Menariya · April 18, 2021, 4:11pm

Yes I'm getting this error after the operations.

I have created new version of web app and I'm using latest version Only.

Error is closing auto and not written anything.

Any other possibility where I'm doing mistake?

TIMAI2 · April 18, 2021, 4:36pm

If you do not show me anything I cannot help!

Please show a copy of your web app script

Please show the full content of the error response

Please show your relevant blocks in full

Vinod_Menariya · April 18, 2021, 4:52pm

Hi,
I'm using below web app script kindly support.

function doGet(e){
  var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1oA9-TFJfEZ1JjJKVKX5B4hHo-KSyi9NDpICbZWczDM/edit#gid=0");
  var sheet = ss.getSheetByName("Sheet1");
  addUser(e,sheet);  
}

function doPost(e){
  var ss = SpreadsheetApp.openByUrl("https://docs.google.com/spreadsheets/d/1oA9-TFJfEZ1JjJKVKX5B4hHo-KSyi9NDpICbZWczDM/edit#gid=0");
  var sheet= ss.getSheetByName("Sheet1");
  addUser(e,sheet);
}

function addUser(e,sheet){
  var ID= e.parameter.ID;
  var NAME = e.parameter.NAME;
  
  sheet.appendRow([ID,NAME]);
 }

TIMAI2 · April 18, 2021, 5:08pm

You probably just need to add return to each of your script calls

See here and compare your script:

Vinod_Menariya · April 18, 2021, 5:41pm

Thanks for your support .
I have changed web script as you shared even I'm getting same error.
Error popup is auto closing and not showing full error that popup is not able to scroll also to view the full error code.

TIMAI2 · April 18, 2021, 5:45pm

set your responseContent to a label, then you can access this content in the companion with a Do It on the label.txt

Vinod_Menariya · April 18, 2021, 6:00pm

Hi ,
Can you share sample block pls.

I'm beginner on AI so kindly help .

TIMAI2 · April 18, 2021, 6:04pm

I did, three posts up...

Vinod_Menariya · April 19, 2021, 2:14am

No changes same error is getting I have done all blocks same as above shown .

TIMAI2 · April 19, 2021, 8:07am

Get your app running in companion

Setup you web1.gottext blocks like this with a label.
Click your send data button
Right click on the label1.text block and select Do It

Select all the text in the Do It dialog

Paste all the text here

Vinod_Menariya · April 19, 2021, 8:53am

Hi below is the first prat of error code unable to past in sigle reply

Do It Result: "

Sign in - Google Accounts @font-face { font-family: 'Open Sans'; font-style: normal; font-weight: 300; src: url(//fonts.gstatic.com/s/opensans/v15/mem5YaGs126MiZpBA-UN_r8OUuhsKKSTjw.ttf) format('truetype'); } @font-face { font-family: 'Open Sans'; font-style: normal; font-weight: 400; src: url(//fonts.gstatic.com/s/opensans/v15/mem8YaGs126MiZpBA-UFVZ0ef8pkAg.ttf) format('truetype'); } h1, h2 { -webkit-animation-duration: 0.1s; -webkit-animation-name: fontfix; -webkit-animation-iteration-count: 1; -webkit-animation-timing-function: linear; -webkit-animation-delay: 0; } @-webkit-keyframes fontfix { from { opacity: 1; } to { opacity: 1; } } html, body { font-family: Arial, sans-serif; background: #fff; margin: 0; padding: 0; border: 0; position: absolute; height: 100%; min-width: 100%; font-size: 13px; color: #404040; direction: ltr; -webkit-text-size-adjust: none; } button, input[type=button], input[type=submit] { font-family: Arial, sans-serif; font-size: 13px; } a, a:hover, a:visited { color: #427fed; cursor: pointer; text-decoration: none; } a:hover { text-decoration: underline; } h1 { font-size: 20px; color: #262626; margin: 0 0 15px; font-weight: normal; } h2 { font-size: 14px; color: #262626; margin: 0 0 15px; font-weight: bold; } input[type=email], input[type=number], input[type=password], input[type=tel], input[type=text], input[type=url] { -moz-appearance: none; -webkit-appearance: none; appearance: none; display: inline-block; height: 36px; padding: 0 8px; margin: 0; background: #fff; border: 1px solid #d9d9d9; border-top: 1px solid #c0c0c0; -moz-box-sizing: border-box; -webkit-box-sizing: border-box; box-sizing: border-box; -moz-border-radius: 1px; -webkit-border-radius: 1px; border-radius: 1px; font-size: 15px; color: #404040; } input[type=email]:hover, input[type=number]:hover, input[type=password]:hover, input[type=tel]:hover, input[type=text]:hover, input[type=url]:hover { border: 1px solid #b9b9b9; border-top: 1px solid #a0a0a0; -moz-box-shadow: inset 0 1px 2px rgba(0,0,0,0.1); -webkit-box-shadow: inset 0 1px 2px rgba(0,0,0,0.1); box-shadow: inset 0 1px 2px rgba(0,0,0,0.1); } input[type=email]:focus, input[type=number]:focus, input[type=password]:focus, input[type=tel]:focus, input[type=text]:focus, input[type=url]:focus { outline: none; border: 1px solid #4d90fe; -moz-box-shadow: inset 0 1px 2px rgba(0,0,0,0.3); -webkit-box-shadow: inset 0 1px 2px rgba(0,0,0,0.3); box-shadow: inset 0 1px 2px rgba(0,0,0,0.3); } input[type=checkbox], input[type=radio] { -webkit-appearance: none; display: inline-block; width: 13px; height: 13px; margin: 0; cursor: pointer; vertical-align: bottom; background: #fff; border: 1px solid #c6c6c6; -moz-border-radius: 1px; -webkit-border-radius: 1px; border-radius: 1px; -moz-box-sizing: border-box; -webkit-box-sizing: border-box; box-sizing: border-box; position: relative; } input[type=checkbox]:active, input[type=radio]:active { background: #ebebeb; } input[type=checkbox]:hover { border-color: #c6c6c6; -moz-box-shadow: inset 0 1px 2px rgba(0,0,0,0.1); -webkit-box-shadow: inset 0 1px 2px rgba(0,0,0,0.1); box-shadow: inset 0 1px 2px rgba(0,0,0,0.1); } input[type=radio] { -moz-border-radius: 1em; -webkit-border-radius: 1em; border-radius: 1em; width: 15px; height: 15px; } input[type=checkbox]:checked, input[type=radio]:checked { background: #fff; } input[type=radio]:checked::after { content: ''; display: block; position: relative; top: 3px; left: 3px; width: 7px; height: 7px; background: #666; -moz-border-radius: 1em; -webkit-border-radius: 1em; border-radius: 1em; } input[type=checkbox]:checked::after { content: url(https://ssl.gstatic.com/ui/v1/menu/checkmark.png); display: block; position: absolute; top: -6px; left: -5px; } input[type=checkbox]:focus { outline: none; border-color: #4d90fe; } .stacked-label { display: block; font-weight: bold; margin: .5em 0; } .hidden-label { position: absolute !important; clip: rect(1px 1px 1px 1px); /* IE6, IE7 */ clip: rect(1px, 1px, 1px, 1px); height: 0px; width: 0px; overflow: hidden; visibility: hidden; } input[type=checkbox].form-error, input[type=email].form-error, input[type=number].form-error, input[type=password].form-error, input[type=text].form-error, input[type=tel].form-error, input[type=url].form-error { border: 1px solid #dd4b39; } .error-msg { margin: .5em 0; display: block; color: #dd4b39; line-height: 17px; } .help-link { background: #dd4b39; padding: 0 5px; color: #fff; font-weight: bold; display: inline-block; -moz-border-radius: 1em; -webkit-border-radius: 1em; border-radius: 1em; text-decoration: none; position: relative; top: 0px; } .help-link:visited { color: #fff; } .help-link:hover { color: #fff; background: #c03523; text-decoration: none; } .help-link:active { opacity: 1; background: #ae2817; } .wrapper { position: relative; min-height: 100%; } .content { padding: 0 44px; } .main { padding-bottom: 100px; } /* For modern browsers */ .clearfix:before, .clearfix:after { content: ""; display: table; } .clearfix:after { clear: both; } /* For IE 6/7 (trigger hasLayout) */ .clearfix { zoom:1; } .google-header-bar { height: 71px; border-bottom: 1px solid #e5e5e5; overflow: hidden; } .header .logo { background-image: url(https://ssl.gstatic.com/accounts/ui/logo_1x.png); background-size: 116px 38px; background-repeat: no-repeat; margin: 17px 0 0; float: left; height: 38px; width: 116px; } .header .logo-w { background-image: url(https://ssl.gstatic.com/images/branding/googlelogo/1x/googlelogo_color_112x36dp.png); background-size: 112px 36px; margin: 21px 0 0; } .header .secondary-link { margin: 28px 0 0; float: right; } .header .secondary-link a { font-weight: normal; } .google-header-bar.centered { border: 0; height: 108px; } .google-header-bar.centered .header .logo { float: none; margin: 40px auto 30px; display: block; } .google-header-bar.centered .header .secondary-link { display: none } .google-footer-bar { position: absolute; bottom: 0; height: 35px; width: 100%; border-top: 1px solid #e5e5e5; overflow: hidden; } .footer { padding-top: 7px; font-size: .85em; white-space: nowrap; line-height: 0; } .footer ul { float: left; max-width: 80%; min-height: 16px; padding: 0; } .footer ul li { color: #737373; display: inline; padding: 0; padding-right: 1.5em; } .footer a { color: #737373; } .lang-chooser-wrap { float: right; display: inline; } .lang-chooser-wrap img { vertical-align: top; } .lang-chooser { font-size: 13px; height: 24px; line-height: 24px; } .lang-chooser option { font-size: 13px; line-height: 24px; } .hidden { height: 0px; width: 0px; overflow: hidden; visibility: hidden; display: none !important; } .banner { text-align: center; } .card { background-color: #f7f7f7; padding: 20px 25px 30px; margin: 0 auto 25px; width: 304px; -moz-border-radius: 2px; -webkit-border-radius: 2px; border-radius: 2px; -moz-box-shadow: 0px 2px 2px rgba(0, 0, 0, 0.3); -webkit-box-shadow: 0px 2px 2px rgba(0, 0, 0, 0.3); box-shadow: 0px 2px 2px rgba(0, 0, 0, 0.3); } .card > *:first-child { margin-top: 0; } .rc-button, .rc-button:visited { display: inline-block; min-width: 46px; text-align: center; color: #444; font-size: 14px; font-weight: 700; height: 36px; padding: 0 8px; line-height: 36px; -moz-border-radius: 3px; -webkit-border-radius: 3px; border-radius: 3px; -o-transition: all 0.218s; -moz-transition: all 0.218s; -webkit-transition: all 0.218s; transition: all 0.218s; border: 1px solid #dcdcdc; background-color: #f5f5f5; background-image: -webkit-linear-gradient(top,#f5f5f5,#f1f1f1); background-image: -moz-linear-gradient(top,#f5f5f5,#f1f1f1); background-image: -ms-linear-gradient(top,#f5f5f5,#f1f1f1); background-image: -o-linear-gradient(top,#f5f5f5,#f1f1f1); background-image: linear-gradient(top,#f5f5f5,#f1f1f1); -o-transition: none; -moz-user-select: none; -webkit-user-select: none; user-select: none; cursor: default; } .card .rc-button { width: 100%; padding: 0; } .rc-button.disabled, .rc-button[disabled] { opacity: .5; filter: alpha(opacity=50); cursor: default; pointer-events: none; } .rc-button:hover { border: 1px solid #c6c6c6; color: #333; text-decoration: none; -o-transition: all 0.0s; -moz-transition: all 0.0s; -webkit-transition: all 0.0s; transition: all 0.0s; background-color: #f8f8f8; background-image: -webkit-linear-gradient(top,#f8f8f8,#f1f1f1); background-image: -moz-linear-gradient(top,#f8f8f8,#f1f1f1); background-image: -ms-linear-gradient(top,#f8f8f8,#f1f1f1); background-image: -o-linear-gradient(top,#f8f8f8,#f1f1f1); background-image: linear-gradient(top,#f8f8f8,#f1f1f1); -moz-box-shadow: 0 1px 1px rgba(0,0,0,0.1); -webkit-box-shadow: 0 1px 1px rgba(0,0,0,0.1); box-shadow: 0 1px 1px rgba(0,0,0,0.1); } .rc-button:active { background-color: #f6f6f6; background-image: -webkit-linear-gradient(top,#f6f6f6,#f1f1f1); background-image: -moz-linear-gradient(top,#f6f6f6,#f1f1f1); background-image: -ms-linear-gradient(top,#f6f6f6,#f1f1f1); background-image: -o-linear-gradient(top,#f6f6f6,#f1f1f1); background-image: linear-gradient(top,#f6f6f6,#f1f1f1); -moz-box-shadow: 0 1px 2px rgba(0,0,0,0.1); -webkit-box-shadow: 0 1px 2px rgba(0,0,0,0.1); box-shadow: 0 1px 2px rgba(0,0,0,0.1); } .rc-button-submit, .rc-button-submit:visited { border: 1px solid #3079ed; color: #fff; text-shadow: 0 1px rgba(0,0,0,0.1); background-color: #4d90fe; background-image: -webkit-linear-gradient(top,#4d90fe,#4787ed); background-image: -moz-linear-gradient(top,#4d90fe,#4787ed); background-image: -ms-linear-gradient(top,#4d90fe,#4787ed); background-image: -o-linear-gradient(top,#4d90fe,#4787ed); background-image: linear-gradient(top,#4d90fe,#4787ed); } .rc-button-submit:hover { border: 1px solid #2f5bb7; color: #fff; text-shadow: 0 1px rgba(0,0,0,0.3); background-color: #357ae8; background-image: -webkit-linear-gradient(top,#4d90fe,#357ae8); background-image: -moz-linear-gradient(top,#4d90fe,#357ae8); background-image: -ms-linear-gradient(top,#4d90fe,#357ae8); background-image: -o-linear-gradient(top,#4d90fe,#357ae8); background-image: linear-gradient(top,#4d90fe,#357ae8); } .rc-button-submit:active { background-color: #357ae8; background-image: -webkit-linear-gradient(top,#4d90fe,#357ae8); background-image: -moz-linear-gradient(top,#4d90fe,#357ae8); background-image: -ms-linear-gradient(top,#4d90fe,#357ae8); background-image: -o-linear-gradient(top,#4d90fe,#357ae8); background-image: linear-gradient(top,#4d90fe,#357ae8); -moz-box-shadow: inset 0 1px 2px rgba(0,0,0,0.3); -webkit-box-shadow: inset 0 1px 2px rgba(0,0,0,0.3); box-shadow: inset 0 1px 2px rgba(0,0,0,0.3); } .rc-button-red, .rc-button-red:visited { border: 1px solid transparent; color: #fff; text-shadow: 0 1px rgba(0,0,0,0.1); background-color: #d14836; background-image: -webkit-linear-gradient(top,#dd4b39,#d14836); background-image: -moz-linear-gradient(top,#dd4b39,#d14836); background-image: -ms-linear-gradient(top,#dd4b39,#d14836); background-image: -o-linear-gradient(top,#dd4b39,#d14836); background-image: linear-gradient(top,#dd4b39,#d14836); } .rc-button-red:hover { border: 1px solid #b0281a; color: #fff; text-shadow: 0 1px rgba(0,0,0,0.3); background-color: #c53727; background-image: -webkit-linear-gradient(top,#dd4b39,#c53727); background-image: -moz-linear-gradient(top,#dd4b39,#c53727); background-image: -ms-linear-gradient(top,#dd4b39,#c53727); background-image: -o-linear-gradient(top,#dd4b39,#c53727); background-image: linear-gradient(top,#dd4b39,#c53727); } .rc-button-red:active { border: 1px solid #992a1b; background-color: #b0281a; background-image: -webkit-linear-gradient(top,#dd4b39,#b0281a); background-image: -moz-linear-gradient(top,#dd4b39,#b0281a); background-image: -ms-linear-gradient(top,#dd4b39,#b0281a); background-image: -o-linear-gradient(top,#dd4b39,#b0281a); background-image: linear-gradient(top,#dd4b39,#b0281a); -moz-box-shadow: inset 0 1px 2px rgba(0,0,0,0.3); -webkit-box-shadow: inset 0 1px 2px rgba(0,0,0,0.3); box-shadow: inset 0 1px 2px rgba(0,0,0,0.3); } .secondary-actions { text-align: center; } .google-header-bar.centered { height: 83px; } .google-header-bar.centered .header .logo { margin: 25px auto 20px; } .card { margin-bottom: 20px; } html, body { font-size: 14px; } .google-header-bar.centered { height: 73px; } .google-header-bar.centered .header .logo { margin: 20px auto 15px; } .content { padding-left: 10px; padding-right: 10px; } .hidden-small { display: none; } .card { padding: 20px 15px 30px; width: 270px; } .footer ul li { padding-right: 1em; } .lang-chooser-wrap { display: none; } .header .logo { background-image: url(https://ssl.gstatic.com/accounts/ui/logo_2x.png); } .header .logo-w { background-image: url(https://ssl.gstatic.com/images/branding/googlelogo/2x/googlelogo_color_112x36dp.png); } pre.debug { font-family: monospace; position: absolute; left: 0; margin: 0; padding: 1.5em; font-size: 13px; background: #f1f1f1; border-top: 1px solid #e5e5e5; direction: ltr; white-space: pre-wrap; width: 90%; overflow: hidden; } .banner h1 { font-family: 'Open Sans', arial; -webkit-font-smoothing: antialiased; color: #555; font-size: 42px; font-weight: 300; margin-top: 0; margin-bottom: 20px; } .banner h2 { font-family: 'Open Sans', arial; -webkit-font-smoothing: antialiased; color: #555; font-size: 18px; font-weight: 400; margin-bottom: 20px; } .signin-card { width: 274px; padding: 40px 40px; } .signin-card .profile-img { width: 96px; height: 96px; margin: 0 auto 10px; display: block; -moz-border-radius: 50%; -webkit-border-radius: 50%; border-radius: 50%; } .signin-card .profile-name { font-size: 16px; font-weight: bold; text-align: center; margin: 10px 0 0; min-height: 1em; } .signin-card .profile-email { font-size: 16px; text-align: center; margin: 10px 0 20px 0; min-height: 1em; } .signin-card input[type=email], .signin-card input[type=password], .signin-card input[type=text], .signin-card input[type=submit] { width: 100%; display: block; margin-bottom: 10px; z-index: 1; position: relative; -moz-box-sizing: border-box; -webkit-box-sizing: border-box; box-sizing: border-box; } .signin-card #Email, .signin-card #Passwd, .signin-card .captcha { direction: ltr; height: 44px; font-size: 16px; } .signin-card #Email + .stacked-label { margin-top: 15px; } .signin-card #reauthEmail { display: block; margin-bottom: 10px; line-height: 36px; padding: 0 8px; font-size: 15px; color: #404040; line-height: 2; margin-bottom: 10px; font-size: 14px; text-align: center; overflow: hidden; text-overflow: ellipsis; white-space: nowrap; -moz-box-sizing: border-box; -webkit-box-sizing: border-box; box-sizing: border-box; } .one-google p { margin: 0 0 10px; color: #555; font-size: 14px; text-align: center; } .one-google p.create-account, .one-google p.switch-account { margin-bottom: 60px; } .one-google .logo-strip { background-repeat: no-repeat; display: block; margin: 10px auto; background-image: url(https://ssl.gstatic.com/accounts/ui/wlogostrip_230x17_1x.png); background-size: 230px 17px; width: 230px; height: 17px; } .banner h1 { font-size: 38px; margin-bottom: 15px; } .banner h2 { margin-bottom: 15px; } .one-google p.create-account, .one-google p.switch-account { margin-bottom: 30px; } .signin-card #Email { margin-bottom: 0; } .signin-card #Passwd { margin-top: -1px; } .signin-card #Email.form-error, .signin-card #Passwd.form-error { z-index: 2; } .signin-card #Email:hover, .signin-card #Email:focus, .signin-card #Passwd:hover, .signin-card #Passwd:focus { z-index: 3; } .banner h1 { font-size: 22px; margin-bottom: 15px; } .signin-card { width: 260px; padding: 20px 20px; margin: 0 auto 20px; } .signin-card .profile-img { width: 72px; height: 72px; -moz-border-radius: 72px; -webkit-border-radius: 72px; border-radius: 72px; } .one-google .logo-strip { background-image: url(https://ssl.gstatic.com/accounts/ui/wlogostrip_230x17_2x.png); } .remember .bubble-wrap { position: absolute; padding-top: 3px; -o-transition: opacity .218s ease-in .218s; -moz-transition: opacity .218s ease-in .218s; -webkit-transition: opacity .218s ease-in .218s; transition: opacity .218s ease-in .218s; left: -999em; opacity: 0; width: 314px; margin-left: -20px; } .remember:hover .bubble-wrap, .remember input:focus ~ .bubble-wrap, .remember .bubble-wrap:hover, .remember .bubble-wrap:focus { opacity: 1; left: inherit; } .bubble-pointer { border-left: 10px solid transparent; border-right: 10px solid transparent; border-bottom: 10px solid #fff; width: 0; height: 0; margin-left: 17px; } .bubble { background-color: #fff; padding: 15px; margin-top: -1px; font-size: 11px; -moz-border-radius: 2px; -webkit-border-radius: 2px; border-radius: 2px; -moz-box-shadow: 0px 2px 2px rgba(0, 0, 0, 0.3); -webkit-box-shadow: 0px 2px 2px rgba(0, 0, 0, 0.3); box-shadow: 0px 2px 2px rgba(0, 0, 0, 0.3); } #stay-signed-in { float: left; } #stay-signed-in-tooltip { left: auto; margin-left: -20px; padding-top: 3px; position: absolute; top: 0; visibility: hidden; width: 314px; z-index: 1; } .dasher-tooltip { top: 380px; } .dasher-tooltip { top: 340px; } .jfk-tooltip { background-color: #fff; border: 1px solid; color: #737373; font-size: 12px; position: absolute; z-index: 800 !important; border-color: #bbb #bbb #a8a8a8; padding: 16px; width: 250px; } .jfk-tooltip h3 { color: #555; font-size: 12px; margin: 0 0 .5em; } .jfk-tooltip-content p:last-child { margin-bottom: 0; } .jfk-tooltip-arrow { position: absolute; } .jfk-tooltip-arrow .jfk-tooltip-arrowimplbefore, .jfk-tooltip-arrow .jfk-tooltip-arrowimplafter { display: block; height: 0; position: absolute; width: 0; } .jfk-tooltip-arrow .jfk-tooltip-arrowimplbefore { border: 9px solid; } .jfk-tooltip-arrow .jfk-tooltip-arrowimplafter { border: 8px solid; } .jfk-tooltip-arrowdown { bottom: 0; } .jfk-tooltip-arrowup { top: -9px; } .jfk-tooltip-arrowleft { left: -9px; top: 30px; } .jfk-tooltip-arrowright { right: 0; top: 30px; } .jfk-tooltip-arrowdown .jfk-tooltip-arrowimplbefore,.jfk-tooltip-arrowup .jfk-tooltip-arrowimplbefore { border-color: #bbb transparent; left: -9px; } .jfk-tooltip-arrowdown .jfk-tooltip-arrowimplbefore { border-color: #a8a8a8 transparent; } .jfk-tooltip-arrowdown .jfk-tooltip-arrowimplafter,.jfk-tooltip-arrowup .jfk-tooltip-arrowimplafter { border-color: #fff transparent; left: -8px; } .jfk-tooltip-arrowdown .jfk-tooltip-arrowimplbefore { border-bottom-width: 0; } .jfk-tooltip-arrowdown .jfk-tooltip-arrowimplafter { border-bottom-width: 0; } .jfk-tooltip-arrowup .jfk-tooltip-arrowimplbefore { border-top-width: 0; } .jfk-tooltip-arrowup .jfk-tooltip-arrowimplafter { border-top-width: 0; top: 1px; } .jfk-tooltip-arrowleft .jfk-tooltip-arrowimplbefore, .jfk-tooltip-arrowright .jfk-tooltip-arrowimplbefore { border-color: transparent #bbb; top: -9px; } .jfk-tooltip-arrowleft .jfk-tooltip-arrowimplafter, .jfk-tooltip-arrowright .jfk-tooltip-arrowimplafter { border-color:transparent #fff; top:-8px; } .jfk-tooltip-arrowleft .jfk-tooltip-arrowimplbefore { border-left-width: 0; } .jfk-tooltip-arrowleft .jfk-tooltip-arrowimplafter { border-left-width: 0; left: 1px; } .jfk-tooltip-arrowright .jfk-tooltip-arrowimplbefore { border-right-width: 0; } .jfk-tooltip-arrowright .jfk-tooltip-arrowimplafter { border-right-width: 0; } .jfk-tooltip-closebtn { background: url("//ssl.gstatic.com/ui/v1/icons/common/x_8px.png") no-repeat; border: 1px solid transparent; height: 21px; opacity: .4; outline: 0; position: absolute; right: 2px; top: 2px; width: 21px; } .jfk-tooltip-closebtn:focus, .jfk-tooltip-closebtn:hover { opacity: .8; cursor: pointer; } .jfk-tooltip-closebtn:focus { border-color: #4d90fe; } .jfk-tooltip { display: none; } .captcha-box { background: #fff; margin: 0 0 10px; overflow: hidden; padding: 10px; } .captcha-box .captcha-img { text-align: center; } .captcha-box .captcha-label { font-weight: bold; display: block; margin: .5em 0; } .captcha-box .captcha-msg { color: #999; display: block; position: relative; } .captcha-box .captcha-msg .accessibility-logo { float: right; border: 0; } .captcha-box .audio-box { position: absolute; top: 0; } .chromiumsync-custom-content { padding-top: 20px; margin-bottom: 0; } .form-panel { -webkit-box-sizing: border-box; box-sizing: border-box; -webkit-transform: translateZ(0); -moz-transform: translateZ(0); -ms-transform: translateZ(0); -o-transform: translateZ(0); transform: translateZ(0); width: 100%; } .form-panel.first { z-index: 2; } .form-panel.second { z-index: 1; } .shift-form .form-panel.first { z-index: 1; } .shift-form .form-panel.second { z-index: 2; } .slide-in, .slide-out { display: block; -webkit-transition-property: -webkit-transform, opacity; -moz-transition-property: -moz-transform, opacity; -ms-transition-property: -ms-transform, opacity; -o-transition-property: -o-transform, opacity; transition-property: transform, opacity; -webkit-transition-duration: 0.1s; -moz-transition-duration: 0.1s; -ms-transition-duration: 0.1s; -o-transition-duration: 0.1s; transition-duration: 0.1s; -webkit-transition-timing-function: cubic-bezier(0.4, 0, 0.2, 1); -moz-transition-timing-function: cubic-bezier(0.4, 0, 0.2, 1); -ms-transition-timing-function: cubic-bezier(0.4, 0, 0.2, 1); -o-transition-timing-function: cubic-bezier(0.4, 0, 0.2, 1); transition-timing-function: cubic-bezier(0.4, 0, 0.2, 1); } .slide-out { -webkit-transform: translate3d(0, 0, 0); -moz-transform: translate3d(0, 0, 0); -ms-transform: translate3d(0, 0, 0); -o-transform: translate3d(0, 0, 0); transform: translate3d(0, 0, 0); } .shift-form .slide-out { opacity: 0; -webkit-transform: translate3d(-120%, 0, 0); -moz-transform: translate3d(-120%, 0, 0); -ms-transform: translate3d(-120%, 0, 0); -o-transform: translate3d(-120%, 0, 0); transform: translate3d(-120%, 0, 0); } .slide-in { -webkit-transform: translate3d(120%, 0, 0); -moz-transform: translate3d(120%, 0, 0); -ms-transform: translate3d(120%, 0, 0); -o-transform: translate3d(120%, 0, 0); transform: translate3d(120%, 0, 0); } .shift-form .slide-in { opacity: 1; -webkit-transform: translate3d(0, 0, 0); -moz-transform: translate3d(0, 0, 0); -ms-transform: translate3d(0, 0, 0); -o-transform: translate3d(0, 0, 0); transform: translate3d(0, 0, 0); } .error-msg { -webkit-transition: max-height 0.3s, opacity 0.3s 0s steps(10, end); -moz-transition: max-height 0.3s, opacity 0.3s 0s steps(10, end); -ms-transition: max-height 0.3s, opacity 0.3s 0s steps(10, end); -o-transition: max-height 0.3s, opacity 0.3s 0s steps(10, end); transition: max-height 0.3s, opacity 0.3s 0s steps(10, end); height: auto; max-height: 0; opacity: 0; } .has-error .error-msg { max-height: 3.5em; margin-top: 10px; margin-bottom: 10px; opacity: 1; visibility: visible; } .back-arrow { position: absolute; top: 37px; width: 24px; height: 24px; display: none; cursor: pointer; } .back-arrow { border-style: none; } .shift-form.back-arrow { display: block; } .back-arrow img { display: block; } #link-signup { text-align: center; font-size: 14px; } .shift-form #link-signup{ display: none; } #link-signin-different { display: none; text-align: center; font-size: 14px; } .shift-form #link-signin-different { display: block; } .signin-card #profile-name { font-size: 16px; font-weight: bold; text-align: center; margin: 0; min-height: 1em; } .signin-card.no-name #profile-name { display: none; } .signin-card.no-name #email-display { line-height: initial; margin-bottom: 16px; } .signin-card #email-display { display: block; padding: 0px 8px; color: rgb(64, 64, 64); line-height: 2; margin-bottom: 10px; font-size: 14px; text-align: center; overflow: hidden; text-overflow: ellipsis; white-space: nowrap; -moz-box-sizing: border-box; -webkit-box-sizing: border-box; box-sizing: border-box; } .signin-card #Email { margin-top: 16px; } .need-help { float: right; text-align: right; } .form-panel { width: 274px; } #gaia_firstform { z-index: 2; } .signin-card { position: relative; overflow: hidden; } .signin-card #profile-name { color: #000; } .circle-mask { display: block; height: 96px; width: 96px; overflow: hidden; border-radius: 50%; margin-left: auto; margin-right: auto; z-index: 100; margin-bottom: 10px; } .circle { -webkit-transition-property: -webkit-transform; -moz-transition-property: -moz-transform; -ms-transition-property: -ms-transform; -o-transition-property: -o-transform; transition-property: transform; -webkit-transition-timing-function: cubic-bezier(.645,.045,.355,1); -moz-transition-timing-function: cubic-bezier(.645,.045,.355,1); -ms-transition-timing-function: cubic-bezier(.645,.045,.355,1); -o-transition-timing-function: cubic-bezier(.645,.045,.355,1); transition-timing-function: cubic-bezier(.645,.045,.355,1); } .circle { position: absolute; z-index: 101; height: 96px; width: 96px; border-radius: 50%; opacity: 0.99; overflow: hidden; background-repeat: no-repeat; background-position: center center; } .main { overflow: hidden; } .card-mask-wrap { position: relative; width: 360px; margin: 0 auto; z-index: 1; } .dasher-tooltip { position: absolute; left: 50%; margin-left: 150px; } .dasher-tooltip .tooltip-pointer { margin-top: 15px; } .dasher-tooltip p { margin-top: 0; } .dasher-tooltip p span { display: block; } .card { margin-bottom: 0; } .one-google { padding-top: 27px; } #canvas { -webkit-transition: opacity 0.075s; -moz-transition: opacity 0.075s; -ms-transition: opacity 0.075s; -o-transition: opacity 0.075s; transition: opacity 0.075s; opacity: 0.01; } .shift-form #canvas { opacity: 0.99; } .label { color: #404040; } #account-chooser-link { -webkit-transition: opacity 0.3s; -moz-transition: opacity 0.3s; -ms-transition: opacity 0.3s; -o-transition: opacity 0.3s; transition: opacity 0.3s; } .input-wrapper { position: relative; } .google-footer-bar { z-index: 2; } .back-arrow { top: 17px; } .circle-mask { height: 72px; width: 72px; background-size: 72px; } .circle { height: 72px; width: 72px; } #canvas { height: 72px; width: 72px; } .form-panel { width: 256px; } .card-mask-wrap { width: 300px; } .signin-card { width: 256px; } .signin-card #EmailFirst { margin-top: 15px; } .one-google { padding-top: 22px; }

One account. All of Google.

Sign in with your Google Account

<div class="main-content <pre><code>no-name </code></pre> <p>"></p> <div class="card signin-card pre-shift

no-name">
<img class="circle-mask"

Vinod_Menariya · April 19, 2021, 8:55am

2nd part continue---

src="https://ssl.gstatic.com/accounts/ui/avatar_2x.png"
>

Enter your email <input id="Email" type="email" value="" spellcheck="false" name="Email"

                 placeholder="Email or phone"
               
               
               
               >

Find my account

Sign in with a different account Create account

One Google Account for everything Google

Vinod_Menariya · April 19, 2021, 8:57am

3rd --

TIMAI2 · April 19, 2021, 12:13pm

This seems to indicate that your web app script url is incorrect in your app, or that you have not correctly published your web app to a new version. Check these issues.

Vinod_Menariya · April 27, 2021, 7:25pm

Hi TIMAI2,

I have checked and new web app url taken even its seems same error. and from that URL i can send data to sheet by suing browser.

TIMAI2 · April 27, 2021, 7:37pm

From what you say, your "doGet(e)" script is working in your browser, but your doPost(e) script is not working in your app.

change your app to use doGet(e) ?

To keep using doPost(e) see here

Google Sheets - Simple POST and GET Data

Blocks like this:

and edit your script to match.