# APP para agendamentos de serviços

**URL:** <https://community.glideapps.com/t/app-para-agendamentos-de-servicos/18676>\
**Category:** Project Showcase\
**Created:** [November 19, 2020, 4:57pm UTC](https://community.glideapps.com/t/app-para-agendamentos-de-servicos/18676 "2020-11-19T16:57:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![leandro](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leandro/32/16780_2.png) [@leandro](https://community.glideapps.com/u/leandro)\
**Post date:** [November 19, 2020, 4:57pm UTC](https://community.glideapps.com/t/app-para-agendamentos-de-servicos/18676/1 "2020-11-19T16:57:39Z")

</div>

> **[agendar app](https://agendar-app.glideapp.io/)**

LOGIN PARA ADM LOGIN: leandro001 SENHA: 123

SCRIPT PARA CRIAR EVENTO NA AGENDA DO GOOGLE DE ACORDO COM A DATA AGENDADA NO APP

var calendario = CalendarApp.getCalendarsByName(“INSIRA SEU EMAIL AQUI”)[0];

var agendamentos = SpreadsheetApp.getActiveSpreadsheet().getSheetByName(“Agendamentos”);  
var lrA = agendamentos.getLastRow();

function init() {

var agendados = agendamentos.getRange(1, 3).getValue();  
var notificados = agendamentos.getRange(1, 4).getValue();

if(agendados \> notificados){  
coletarInformacoes(notificados);  
}  
}

function coletarInformacoes(notificados){

for(var i = notificados; i \<=lrA; i++){  
var notificado = agendamentos.getRange(i, 2).getValue();

```
if(notificado != "Notificado"){
  var nome = agendamentos.getRange(i, 7).getValue();
  var whats = agendamentos.getRange(i, 8).getValue();
  var servico = agendamentos.getRange(i, 11).getValue();
  var descricao = "Nome: " +nome+" Whatsapp: "+whats+" Serviço: " +servico;
  
  var data = agendamentos.getRange(i, 5).getValue();
  var startTime = new Date(data);
  var dataObj = new Date(data);
  var endTime = new Date(dataObj.setMinutes(dataObj.getMinutes() + 30));
  
  
  calendario.createEvent("Novo agendamento", startTime, endTime, {description: descricao});
  agendamentos.getRange(i, 2).setValue("Notificado");
  
}

```

}  
}

---

<div class="post-metadata">

**Author:** ![Bonner\_Live](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/bonner_live/32/35933_2.png) [@Bonner\_Live](https://community.glideapps.com/u/Bonner_Live)\
**Post date:** [January 31, 2022, 12:25am UTC](https://community.glideapps.com/t/app-para-agendamentos-de-servicos/18676/2 "2022-01-31T00:25:59Z")

</div>

Top! Tem como mandar uma cópia amigo?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [January 31, 2022, 2:02am UTC](https://community.glideapps.com/t/app-para-agendamentos-de-servicos/18676/3 "2022-01-31T02:02:05Z")

</div>

@Bonner_Live It looks like the app already can be copied. Just open the link and click on the copy button.