Nesse vídeo eu mostro como exportar submissões automaticamente para Planilhas do Google usando Apps Script e webhook do Elementor (PRO) Form.
Veja o vídeo:
É um recurso bem interessante porque você pode colecionar dados de formulários criados com Elementor em planilhas (Google Sheet).
O Google Sheets é um programa de planilhas incluído como parte do pacote gratuito de Editores de Documentos Google baseado na Web oferecido pelo Google.
O Google Apps Script é uma plataforma de script desenvolvida pelo Google para desenvolvimento de aplicativos leves na plataforma Google Workspace.
Elementor Ltd. é uma empresa israelense de software que fornece serviços de desenvolvimento web.
O construtor de sites (Page Builder) Elementor permite que os usuários do WordPress criem e editem sites empregando a técnica de arrastar e soltar, com um modo responsivo integrado.
Aqui está o código para usar no Apps Script
function doGet(e){
return HtmlService.createHtmlOutput('solicitação recebida');
}
function doPost(e){
if(typeof e !== 'undefined')
var parametros = e.parameter;
var planilha = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Newsletter');
var ultimeLinha = Math.max(planilha.getLastRow(),1);
var linhaAtual = ultimeLinha + 1;
planilha.insertRowAfter(ultimeLinha);
var nome = parametros['Nome'];
var email = parametros['E-mail'];
var whatsapp = parametros['WhatsApp'];
planilha.getRange(linhaAtual, 1).setValue(nome);
planilha.getRange(linhaAtual, 2).setValue(email);
planilha.getRange(linhaAtual, 3).setValue(whatsapp);
SpreadsheetApp.flush();
return HtmlService.createHtmlOutput('Solicitação recebida!');
}
Pegue o código no Github – Clique aqui.
125 respostas
Parabéns pelo conteudo nobre Professor, achei o conteúdo muito rico, me permite usar o elementos para coletar varios dados de pesquisa. tenho um cliente hoje que precisa fazer um cadastro de colaboradores. E a partir da sua solução , eu poderei manter os dados no meu drive, inclusive para gerar dados estatitiscios e demograficos importantes para esse projeto.
Uma grande dúvida que tenho, está relacionada e aplicação deste código para gerar uma interação com um auto-responder por exemplo. Para que eu possa acionar uma sequência de e-mails de relacionentendo. O auto-responder que utilizo permite ser acionado a partir de um webhook.
pergunta de iniciante
Existe a possibilidade de adicionar um comando para que o mesmo seja acionado usando esse caminho?
Desde já eu agradeço sua atenção
Forte Abraço.
I am sorting out relevant information about gate io recently, and I saw your article, and your creative ideas are of great help to me. However, I have doubts about some creative issues, can you answer them for me? I will continue to pay attention to your reply. Thanks.
Hi there, I enjoy reading through your post. I wanted to write a little comment to support you.
Also visit my page – vpn special coupon code 2024
For latest news you have to visit the web and on internet I
found this site as a most excellent web site for most recent
updates.
Feel free to visit my website – vpn special coupon code 2024
Wow, wonderful blog layout! How long have you ever been blogging for?
you make blogging glance easy. The whole look of your web
site is magnificent, as smartly as the content material! You can see similar here dobry sklep
mexican pharmacy: buying prescription drugs in mexico online – buying from online mexican pharmacy
Online medicine order http://indiaph24.store/# indianpharmacy com
top 10 online pharmacy in india
https://canadaph24.pro/# canadian pharmacy review
reliable canadian pharmacy [url=http://canadaph24.pro/#]canadian pharmacy uk delivery[/url] canadian drugs online
http://indiaph24.store/# cheapest online pharmacy india
https://indiaph24.store/# top 10 online pharmacy in india
Online medicine home delivery https://indiaph24.store/# top 10 pharmacies in india
online shopping pharmacy india
tamoxifen endometrium: tamoxifen for gynecomastia reviews – buy tamoxifen
cytotec abortion pill [url=http://cytotec.club/#]buy cytotec pills online cheap[/url] cytotec abortion pill
http://finasteride.store/# order propecia without prescription
https://cytotec.club/# buy cytotec
buying generic propecia [url=https://finasteride.store/#]order generic propecia no prescription[/url] order propecia for sale
lisinopril brand name uk: lisinopril 20mg pill – zestril price uk
buy ciprofloxacin [url=http://ciprofloxacin.tech/#]buy ciprofloxacin[/url] ciprofloxacin 500 mg tablet price
https://lisinopril.network/# lisinopril 20 12.5 mg
http://nolvadex.life/# tamoxifen endometriosis
Cytotec 200mcg price [url=https://cytotec.club/#]cytotec online[/url] buy cytotec
tamoxifen lawsuit: natural alternatives to tamoxifen – nolvadex during cycle
http://finasteride.store/# buy generic propecia
cytotec pills buy online [url=http://cytotec.club/#]buy cytotec in usa[/url] Abortion pills online
https://ciprofloxacin.tech/# ciprofloxacin 500 mg tablet price
ciprofloxacin mail online [url=https://ciprofloxacin.tech/#]cipro 500mg best prices[/url] ciprofloxacin mail online
purchase cytotec: buy cytotec over the counter – buy cytotec in usa
http://nolvadex.life/# tamoxifen adverse effects
http://nolvadex.life/# natural alternatives to tamoxifen
ciprofloxacin 500mg buy online [url=https://ciprofloxacin.tech/#]cipro pharmacy[/url] п»їcipro generic
clomid nolvadex: tamoxifen dose – tamoxifen effectiveness
https://nolvadex.life/# tamoxifen and depression
cost propecia no prescription [url=https://finasteride.store/#]cost propecia price[/url] rx propecia
cipro [url=https://ciprofloxacin.tech/#]buy ciprofloxacin[/url] cipro for sale
https://cytotec.club/# Misoprostol 200 mg buy online
order cytotec online: buy cytotec online fast delivery – cytotec buy online usa
zestril 20 mg tab [url=https://lisinopril.network/#]lisinopril 422[/url] lisinopril 10mg online
https://ciprofloxacin.tech/# buy ciprofloxacin
http://nolvadex.life/# tamoxifen adverse effects
tamoxifen and grapefruit [url=https://nolvadex.life/#]where to get nolvadex[/url] tamoxifen for men
buy ciprofloxacin over the counter: ciprofloxacin 500 mg tablet price – ciprofloxacin mail online
http://cytotec.club/# п»їcytotec pills online
https://cytotec.club/# п»їcytotec pills online
medicine lisinopril 10 mg [url=http://lisinopril.network/#]lisinopril tablet 40 mg[/url] zestril discount
cipro 500mg best prices [url=http://ciprofloxacin.tech/#]cipro 500mg best prices[/url] ciprofloxacin 500mg buy online
where can i buy cipro online: cipro generic – buy ciprofloxacin
http://lisinopril.network/# lisinopril 5mg tablets
http://lisinopril.network/# lisinopril 2 5 mg tablets
buy cytotec pills [url=https://cytotec.club/#]cytotec online[/url] buy cytotec over the counter
get propecia without dr prescription: order cheap propecia without dr prescription – generic propecia without rx
http://ciprofloxacin.tech/# antibiotics cipro
cipro [url=http://ciprofloxacin.tech/#]ciprofloxacin order online[/url] ciprofloxacin 500 mg tablet price
https://nolvadex.life/# п»їdcis tamoxifen
buy cipro [url=https://ciprofloxacin.tech/#]ciprofloxacin[/url] ciprofloxacin
cost for generic lisinopril: zestril 5 mg tablets – best generic lisinopril
https://ciprofloxacin.tech/# cipro for sale
buy lisinopril without prescription [url=http://lisinopril.network/#]lisinopril 500 mg[/url] how much is lisinopril 20 mg
http://lisinopril.network/# lisinopril 10mg tablet
buy cytotec in usa: Cytotec 200mcg price – purchase cytotec
cheap propecia pills [url=http://finasteride.store/#]buying cheap propecia without dr prescription[/url] cost of generic propecia without insurance
http://ciprofloxacin.tech/# buy ciprofloxacin over the counter
Buy Cenforce 100mg Online: buy cenforce – Cenforce 150 mg online
Viagra online price [url=https://viagras.online/#]viagras.online[/url] Viagra without a doctor prescription Canada
http://cialist.pro/# Cheap Cialis
cheapest cialis: Cialis 20mg price in USA – Cheap Cialis
Buy Tadalafil 5mg: buy cialis pill – Tadalafil price
https://viagras.online/# Viagra online price
Cenforce 100mg tablets for sale [url=http://cenforce.pro/#]cenforce for sale[/url] cheapest cenforce
http://viagras.online/# Viagra generic over the counter
Generic Cialis price [url=https://cialist.pro/#]Generic Cialis without a doctor prescription[/url] cialis for sale
https://cialist.pro/# Buy Tadalafil 5mg
http://cenforce.pro/# Cenforce 100mg tablets for sale
cenforce for sale [url=http://cenforce.pro/#]cenforce for sale[/url] Cenforce 150 mg online
buy Kamagra: kamagra.win – super kamagra
Levitra tablet price: Buy Vardenafil 20mg – Buy generic Levitra online
http://kamagra.win/# buy kamagra online usa
Kamagra 100mg price [url=https://kamagra.win/#]kamagra.win[/url] cheap kamagra
https://levitrav.store/# Vardenafil buy online
Levitra 10 mg best price: levitrav.store – Generic Levitra 20mg
Kamagra Oral Jelly [url=https://kamagra.win/#]kamagra.win[/url] buy Kamagra
http://cenforce.pro/# order cenforce
buy kamagra online usa: kamagra oral jelly – Kamagra 100mg
legit canadian pharmacy: pharmacies in canada that ship to the us – legit canadian pharmacy online
mexican pharmaceuticals online: mexican mail order pharmacies – mexico drug stores pharmacies
canada online pharmacy [url=http://pharmcanada.shop/#]canadian pharmacy 24[/url] canadian pharmacy 24h com
http://pharmcanada.shop/# best canadian online pharmacy reviews
https://pharmcanada.shop/# canadian pharmacy
reputable mexican pharmacies online: reputable mexican pharmacies online – mexican online pharmacies prescription drugs
buy medicines online in india: indianpharmacy com – indian pharmacy online
online pharmacy canada [url=http://pharmcanada.shop/#]canadian pharmacy[/url] canada drugstore pharmacy rx
http://pharmmexico.online/# mexican pharmacy
canadian pharmacy world coupon: pharm world store – canada pharmacy coupon
indian pharmacies safe [url=https://pharmindia.online/#]indian pharmacy[/url] top 10 pharmacies in india
http://pharmindia.online/# pharmacy website india
legit canadian pharmacy: canadian pharmacy price checker – canadian pharmacy king
how to order prescription drugs from canada [url=https://pharmnoprescription.icu/#]buy medications without prescriptions[/url] canadian pharmacy prescription
mexican pharmacy no prescription: best online prescription – how to get a prescription in canada
pharmacies in mexico that ship to usa: mexican border pharmacies shipping to usa – mexican border pharmacies shipping to usa
https://pharmworld.store/# online pharmacy discount code
buy prescription online [url=https://pharmnoprescription.icu/#]mexico prescription drugs online[/url] canadian pharmacy online no prescription needed
reputable mexican pharmacies online: mexico pharmacy – best online pharmacies in mexico
http://pharmworld.store/# promo code for canadian pharmacy meds
legitimate online pharmacies india: Online medicine home delivery – mail order pharmacy india
mexico drug stores pharmacies [url=http://pharmmexico.online/#]buying prescription drugs in mexico[/url] mexico drug stores pharmacies
top online pharmacy india: top 10 online pharmacy in india – buy prescription drugs from india
http://pharmmexico.online/# mexican online pharmacies prescription drugs
https://pharmnoprescription.icu/# online pharmacies no prescription
how to get zithromax online: zithromax buy online – zithromax for sale usa
doxycycline 200 mg [url=https://doxycyclinea.online/#]doxycycline 100mg dogs[/url] doxycycline 100 mg
where can i buy amoxicillin without prec: amoxicillin 500 mg where to buy – amoxicillin price without insurance
neurontin price india: neurontin 200 mg tablets – neurontin 150 mg
https://gabapentinneurontin.pro/# neurontin generic cost
neurontin tablets 100mg [url=https://gabapentinneurontin.pro/#]neurontin 300 mg cap[/url] gabapentin medication
amoxicillin 500mg capsules price: 875 mg amoxicillin cost – can you buy amoxicillin over the counter in canada
neurontin tablets uk: neurontin 200 mg – cheap neurontin
neurontin 800 mg tablet: neurontin 100mg tablets – neurontin 214
prednisone online india: steroids prednisone for sale – prednisone otc price
purchase doxycycline online: purchase doxycycline online – doxycycline 50 mg
http://doxycyclinea.online/# buy doxycycline online 270 tabs
prednisone over the counter [url=http://prednisoned.online/#]prednisone buy without prescription[/url] buy prednisone without rx
order doxycycline 100mg without prescription: doxy – doxycycline vibramycin
https://doxycyclinea.online/# online doxycycline
buy amoxicillin online without prescription [url=http://amoxila.pro/#]buy amoxicillin over the counter uk[/url] canadian pharmacy amoxicillin
neurontin 100 mg: drug neurontin 20 mg – neurontin cream
amoxicillin for sale: amoxicillin buy canada – buy amoxicillin 250mg
doxycycline: buy doxycycline online – doxycycline
https://gabapentinneurontin.pro/# buying neurontin online
zithromax 1000 mg pills [url=http://zithromaxa.store/#]can you buy zithromax over the counter in mexico[/url] zithromax for sale 500 mg
neurontin 300 mg price in india: neurontin 100mg cap – neurontin capsule 600mg