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🧵
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
⬇️
Read 7 tweets
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.
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).
Read 4 tweets
SQL dumps (database dumps) for #OSINT

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
(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.
Read 14 tweets
It’s #RSTwittorial Thursday! 🙌 Today we’re Generating a Rendered #HTML Diff Report using #Python 🐍🔥

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 🐍🔥
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!)
Read 14 tweets
#RSTwittorial Add Calls-to-Action to Meta Descriptions in #GoogleSheets with #Python 🐍🔥

Here's the output👇
Click on the button that says “Open in Colab"
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 🤯
Read 10 tweets
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)
From inside a folder of @GoogleDrive press

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)
Read 43 tweets

Related hashtags

Did Thread Reader help you today?

Support us! We are indie developers!


This site is made by just two indie developers on a laptop doing marketing, support and development! Read more about the story.

Become a Premium Member ($3.00/month or $30.00/year) and get exclusive features!

Become Premium

Too expensive? Make a small donation by buying us coffee ($5) or help with server cost ($10)

Donate via Paypal Become our Patreon

Thank you for your support!