Generar un documento de Google Docs a partir de mis datos de Google Sheets

Juan S Guzman November 17, 2020
Video Thumbnail
Juan S Guzman Logo

Juan S Guzman

View Channel

About

Videotutoriales semanales de Google Sheets, Google Forms y Apps Scripts. Aquí encontrarán las bases de Google Sheets si es la primera vez que trabajan con esta aplicación. Entre otros temas básicos encontrarán: ¿Qué es Google Sheets? Principales diferencias con Excell Como hacer operaciones básicas Si ya llevan un tiempo trabajando con el software, tambien encontrarán introducción a temas intermedios avanzados como Tablas dinámicas, BUSCARV, QUERY y funciones avanzadas. Así mismo encontrarán aplicaciones prácticas como archivos de gestión de inventarios, listados de tareas y más. También encontrarán tutoriales básicos y avanzados de Google Forms. Por último encontrarán una introducción al mundo de Apps Script, la herramienta de generación de código de Google. Bienvenidos!

Video Description

En este video vemos como crear un documento de Google Doc a partir de una plantilla y datos de una fila de Google Sheets 🗞️ Aquí encuentras una versión más actualizada del tema https://www.youtube.com/playlist?list=PLvrIQ0wr2BTL3S4lXK8uqn1NCWh9fdVeC 👍 Si te ha gustado este video, te encantará el curso gratis "Aprende Google Sheets en 2 horas". Aquí puedes obtener acceso https://juansguzman.com/cursogratis 📋 Puedes encontrar el código y la plantilla de este video (y los más de 350 videos del canal) inscribiéndote en un plan mensual o anual en mi membresía JuanSGuzman - https://juansguzman.com 🎓Allí mismo, encontrarás una serie de cursos de creación y envío de PDFs desde Google Sheets asi como más de 75 cursos completos de Sheets, Forms y Apps Script. Aquí puedes verlo https://juansguzman.com/curso/21-pdf-basico/ 🕒Si no tienes tiempo para hacer el curso y solo necesitas la plantilla actualizada, corregida y con servicio técnico, la puedes adquirir aquí https://juansguzman.com/plantillas/certificados-estudiantes-pdf/ 📝 Puedes encontrar este tutorial en forma escrita aquí https://juansguzman.com/reportes-en-pdf-google-sheets/ 🔔 Suscríbete al canal donde recibirás nuevos videos semanales de Sheets, Forms, Apps Script y más. Aquí algunos canales donde me puedes seguir y apoyar: 📨 - Newsletter: https://juansguzman.com/boletin ➤Patreon: https://juansguzman.com/patreon ➤Telegram: https://juansguzman.com/telegram ➤Instagram: https://juansguzman.com/instagram ⓕ - Facebook: https://juansguzman.com/facebook ➤Tiktok: https://juansguzman.com/tiktok 𝕏 - (Twitter): https://juansguzman.com/twitter Cualquier sugerencia, pregunta o inquietud, te invito a comentar más abajo ➤Si no tienes tiempo para hacer el curso y solo necesitas la plantilla actualizada, corregida y con servicio técnico, la puedes adquirir aquí 📝 Listas de Reproducción relacionadas Combinar Correspondencia - Sheets a PDF - https://www.youtube.com/watch?v=8g2C15DkVbM&list=PLvrIQ0wr2BTL3S4lXK8uqn1NCWh9fdVeC Crear PDFs - https://www.youtube.com/watch?v=TzYiR3ZIi_I&list=PLvrIQ0wr2BTKhfuvlNShn5KDCoRu349JC ▶️Videos Relacionados Creación de menús personalizados en Sheets - https://www.youtube.com/watch?v=z5R1cvOTFUk Parte 2 - Generar PDFs masivos - https://youtu.be/G6RsmY9Z_5c Parte 3 - Generar un documento de texto con Google Sheets - https://youtu.be/qpg1-FuwcX4

You May Also Like

Essential 3D Printing Gear '21

AI-recommended products based on this video

Loading...
SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

(2,468)
$62.99
Loading...
OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

(18,255)
$26.99
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month
Loading...
OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

(18,255)
$26.99
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month
Loading...
SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

(2,468)
$62.99
Loading...
SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

(2,468)
$62.99
Loading...
OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

(18,255)
$26.99
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month
Loading...
SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

(2,468)
$62.99
Loading...
OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

(18,255)
$26.99
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month
Loading...
SUPWEE 3D Nail Sculpting Gel Solid Builder Gel for Nails Art, Non-Sticky Hand Hard Gels for Extension Moding Carving DIY at Home 14g(0.49fl oz)

SUPWEE 3D Nail Sculpting Gel Solid Builder Gel for Nails Art, Non-Sticky Hand Hard Gels for Extension Moding Carving DIY at Home 14g(0.49fl oz)

(765)
$11.39
200+ bought in past month
Loading...
3D Rolling Ball Maze Cube, Maze Ball, Roller Balls Education Toy, Puzzle M-aze Cube, Roller Balls Mind Teaser for Classroom Party Birthday School Travel Waiting Room Family Gathering

3D Rolling Ball Maze Cube, Maze Ball, Roller Balls Education Toy, Puzzle M-aze Cube, Roller Balls Mind Teaser for Classroom Party Birthday School Travel Waiting Room Family Gathering

(0)
$16.03
FREE delivery Dec 19 - 23Arrives before Christmas
Loading...
Large Labyrinth 3D Puzzles Maze Cube with Rolling Ball, Challenging Brain Teaser Puzzles for Adults & Kids, High-Difficulty Cube Logic Game for Spatial Awareness Focus Training Stress Relief (Blue)

Large Labyrinth 3D Puzzles Maze Cube with Rolling Ball, Challenging Brain Teaser Puzzles for Adults & Kids, High-Difficulty Cube Logic Game for Spatial Awareness Focus Training Stress Relief (Blue)

(3)
$16.99
$5.99 delivery Dec 19 - 29
400+ bought in past month
Loading...
Demon Advent Calendar 2025, 24 Day Christmas Countdown Calendar, 3D H-Hunters Xmas Ornaments, Decorations for Adult Kids Boys Girls Fans (A-1)

Demon Advent Calendar 2025, 24 Day Christmas Countdown Calendar, 3D H-Hunters Xmas Ornaments, Decorations for Adult Kids Boys Girls Fans (A-1)

(2)
$21.99
$9.99 delivery Nov 21 - 27
Loading...
SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

(2,468)
$62.99
Loading...
OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

(18,255)
$26.99
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month
Loading...
Casio Men's Classic Japanese-Quartz Watch with Resin Strap, Black, 21 (Model: AE1200WH-1A)

Casio Men's Classic Japanese-Quartz Watch with Resin Strap, Black, 21 (Model: AE1200WH-1A)

(9,442)
$33.90
FREE delivery Sat, Jun 14 on your first order
300+ bought in past month
Loading...
15Ft Flexible Car Ramp Tracks, Portable Flex Track with Strong Suction Cups,Compatible with 1/64 Diecast Cars,Indoor Outdoor Play Flexible Tracks for Kids,Gifts for 3+ Year Old Boys

15Ft Flexible Car Ramp Tracks, Portable Flex Track with Strong Suction Cups,Compatible with 1/64 Diecast Cars,Indoor Outdoor Play Flexible Tracks for Kids,Gifts for 3+ Year Old Boys

(72)
$35.99
Prime
1K+ bought in past month
Loading...
Gauze Rolls – 40 Rolls- Premium First Aid Supplies for Safe Adventuring–individually wrapped -Flexible, Stretchable, Breathable Gauze Bandage Rolls – 3” x 4.1 Yards Bandage Wrap for Wound Dressing

Gauze Rolls – 40 Rolls- Premium First Aid Supplies for Safe Adventuring–individually wrapped -Flexible, Stretchable, Breathable Gauze Bandage Rolls – 3” x 4.1 Yards Bandage Wrap for Wound Dressing

(2)
$13.25
FREE delivery Tue, Oct 28 on your first order
Loading...
DEAFRAIN Kids Polarized Sunglasses TPEE Unbreakable Flexible Sport Glasses UV Protection for Boys Girls Age 3-7

DEAFRAIN Kids Polarized Sunglasses TPEE Unbreakable Flexible Sport Glasses UV Protection for Boys Girls Age 3-7

(1,453)
$23.99
FREE delivery Sat, Jun 14 on your first order
Loading...
Telaso for Samsung Galaxy S25 Case, 360° Rotation Kickstand Ring Holder Plating Edge Soft Rubber TPU Bumper Slim Flexible Shockproof Protective Phone Case Cover for Samsung S25 2025,Sapphire Blue

Telaso for Samsung Galaxy S25 Case, 360° Rotation Kickstand Ring Holder Plating Edge Soft Rubber TPU Bumper Slim Flexible Shockproof Protective Phone Case Cover for Samsung S25 2025,Sapphire Blue

(122)
$14.99
FREE delivery Sun, Jun 15 on your first order
Loading...
SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

SUNLU High Speed PLA Meta Filament, 4KG PLA 3D Printer Tougher Filament 1.75mm, Dimensional Accuracy +/- 0.02 mm, 4kg Total, 1kg per Spool, Pack of 4, Sky Blue+Mint Green+Sunny Orange+Lemon Yellow

(2,468)
$62.99
Loading...
OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

OVERTURE PLA Filament 1.75mm PLA 3D Printer Filament, 1kg Cardboard Spool (2.2lbs), Dimensional Accuracy +/- 0.02mm, Fit Most FDM Printer (White 1-Pack)

(18,255)
$26.99
FREE delivery Sat, Jun 14 on your first order
200+ bought in past month