Script para PESQUISAR em OUTRA ABA (Cadastro de Clientes) | Planilhas Google

In this second lesson, I'll teach you how to perform an automatic search in another tab of a Google Sheet using Google App Script. The script automatically searches for this ID in another tab of the spreadsheet and retrieves its corresponding registered data. 👉Link to the spreadsheet we will be working with: https://docs.google.com/spreadsheets/... In this second lesson of our project, we will see how to automatically search for an ID in another tab of our spreadsheet. When we type it in, the script will run and retrieve this data automatically. If you haven't seen the first lesson, I advise you to watch it so you don't get lost in this programming and have a step-by-step guide on how to build an automatic customer registration system. Lesson 1 - Customer Registration: 🔴   • Cadastro de Cliente Automático com Google ...   If you've never worked with Google App Script, I've already made a video tutorial introducing this free Google tool. Google App Script - First steps and how to access: 🔴   • Como criar uma função personalizada (Custo...   It's also possible to use Scripts to integrate with all Google applications, further optimizing our time. There's already a video tutorial on this channel teaching how to integrate with Gmail, allowing you to send an automatic email directly from your spreadsheet, all with Google App Script. Lesson on how to send automated emails with Google App Script: 🔴   • SCRIPT para ENVIAR E-MAIL COM ANEXO de uma...   Remember that all important links will always be here in the description for better learning and access to the documents and handouts of the video lessons. ⚠️If you want to master Google Sheets, even if you already know something but still want to learn more about this free Google tool, or even if you know nothing and want to learn from scratch, from basic to advanced, with exclusive Google Sheets content, subscribe so you don't miss any new video lessons on the channel! Link to the Playlist to Master Google Sheets: 🔴   • Como puxar dados de outras abas da planilh...   Teaching from zero to advanced Google Sheets, Google App Script and Data Studio, with tutorials, step-by-step Google Sheets, step-by-step Data Studio and step-by-step Google App Script. So if you want to learn about Google Sheets once and for all, you've come to the right channel. Subscribe and follow all the video lessons on the channel. A big hug and good luck with your spreadsheets!!! Chapters: 00:00 - Introduction to the Customer and Supplier registration lesson 01:30 - How to insert a button to run a script 03:50 - Contribute to project improvements 04:50 - OnEdit function in Google App Script 07:43 - IF with more than one criterion in the script 09:41 - Loop to search for a criterion in another tab of the Google Sheet 15:00 - Convert a row to a column in the script #googlesheets #googlesheets