Discover and read the best of Twitter Threads about #googlesheet
Most recents (6)
#TipManuelBot: Hola!, les traigo un tip para copiar los datos de un Documento protegido de Google Sheets! (Documento que no se permite hacer copia ni descargar por configuración de acceso al document)
#AnalistaOsint #ToolsOsint #ManuelBot #GoogleSheets #CiberINT
🧵ABRO HILO🧵
#AnalistaOsint #ToolsOsint #ManuelBot #GoogleSheets #CiberINT
🧵ABRO HILO🧵
1⃣ En alguna ocasión habremos accedido a documentos públicos de #GoogleSheet (Hojas de cálculo) y al momento de querer copiar, descargar, importar, imprimir o de hacer una copia del documento, nos topamos con que el document está protegido, pero hay una forma de omitir eso!
⬇️
⬇️
2⃣ Pero como siempre digo: en el mundo digital nada es seguro!. Bueno Empezamos:
✅ Imaginemos que nuestro documento a copiar es:
https[:]//docs[.]google[.]com/spreadsheets/d/XXXXX/edit?usp=sharing
(XXXXX es el ID del documento visible en la URL
✅Abrimos una hoja en blanco
⬇️
✅ Imaginemos que nuestro documento a copiar es:
https[:]//docs[.]google[.]com/spreadsheets/d/XXXXX/edit?usp=sharing
(XXXXX es el ID del documento visible en la URL
✅Abrimos una hoja en blanco
⬇️
Hoy me gustaría compartir con vosotros cómo generar contenido con #GPT3 y #GoogleSheet.
Necesitaremos una clave de GPT-3 que la puedes obtener en la web de @OpenAI. A continuación abrimos #GoogleSheet y en el menú de extensiones ejecutamos la opción App Script, es en ese editor donde copias y pegas el código que te dejaré al final del Hilo.
Guardas y Listo.
Guardas y Listo.
Si todo es correcto te aparecerá una opción nueva en tu menú de Google Sheet llamada GPT3.
El ejemplo genera el contenido considerando el término de cada Fila (Horóscopo) en relación con el título de cada columna (Predicción).
El ejemplo genera el contenido considerando el término de cada Fila (Horóscopo) en relación con el título de cada columna (Predicción).
SQL dumps (database dumps) for #OSINT
Super short practical course.
Thread🧵🧵🧵
(12 tweets)
#sql #mysql #phpmyadmin
Super short practical course.
Thread🧵🧵🧵
(12 tweets)
#sql #mysql #phpmyadmin
(1/12)
In @GoogleHacking (exploit-db.com/google-hacking…) there are 176 dorks for searching SQL dumps, which may contain any confidential information.
Simple ex (pic 2):
ivanov ext:sql site:github.com
This query search all sql-files, which contain "ivanov" in #Github
In @GoogleHacking (exploit-db.com/google-hacking…) there are 176 dorks for searching SQL dumps, which may contain any confidential information.
Simple ex (pic 2):
ivanov ext:sql site:github.com
This query search all sql-files, which contain "ivanov" in #Github
(2/12)
Sometimes in this way it's possible find databases with information about orders, customers or employees. Inattentively, site owners forget to close them from indexing in robot.txt.
Such SQL-dumps may contain names, surnames, dates of birth, addresses, phone numbers.
Sometimes in this way it's possible find databases with information about orders, customers or employees. Inattentively, site owners forget to close them from indexing in robot.txt.
Such SQL-dumps may contain names, surnames, dates of birth, addresses, phone numbers.
It’s #RSTwittorial Thursday! 🙌 Today we’re Generating a Rendered #HTML Diff Report using #Python 🐍🔥
Here’s the output 👇
Here’s the output 👇
What are we learning? 👨🏫
🧠 How to generate a visual report showing the difference between the raw HTML and the JavaScript Rendered HTML using the requests_html Python library 🐍🔥
🧠 How to generate a visual report showing the difference between the raw HTML and the JavaScript Rendered HTML using the requests_html Python library 🐍🔥
Why is it practical? 🧐
🔍 When webpages use #JavaScript, the HTML rendered on the client-side 🧑💻 could be different from the raw HTML coming from the server-side ⌨️
🔍 Creating a diff allows you to quickly see 👀 the JavaScript changes 🖥️ (great for JavaScript #SEO!)
🔍 When webpages use #JavaScript, the HTML rendered on the client-side 🧑💻 could be different from the raw HTML coming from the server-side ⌨️
🔍 Creating a diff allows you to quickly see 👀 the JavaScript changes 🖥️ (great for JavaScript #SEO!)
#RSTwittorial Add Calls-to-Action to Meta Descriptions in #GoogleSheets with #Python 🐍🔥
Here's the output👇
Here's the output👇
Click on the button that says “Open in Colab"
github.com/ranksense/Twit…
github.com/ranksense/Twit…
Why learn this? 🧐
Skip the tedious work of updating 100s or 1,000s of meta descriptions and let this script do it for you! Speed up your processing time from 30 sec/URL to 3 sec/URL 🤯
Skip the tedious work of updating 100s or 1,000s of meta descriptions and let this script do it for you! Speed up your processing time from 30 sec/URL to 3 sec/URL 🤯
Mega thread of #GoogleSheets #productivity tips & tricks coming up...
Starting with this humdinger
Type “sheet.new” or "sheets.new" into your browser to instantly create a new Google Sheet
(1/n)
Starting with this humdinger
Type “sheet.new” or "sheets.new" into your browser to instantly create a new Google Sheet
(1/n)
From inside a folder of @GoogleDrive press
Shift + S
To create a new Google Sheet in that folder
(2/n)
Shift + S
To create a new Google Sheet in that folder
(2/n)
Quickly freeze panes in your #GoogleSheet by hovering over the border of the sheet (just under the column letters) until you see the hand icon.
Drag down as many rows as you want to freeze.
Works for columns too!
(3/n)
Drag down as many rows as you want to freeze.
Works for columns too!
(3/n)
