How To Check a Website’s Language In Google Sheets

😴 Video not loading? Try loading it on the Muse.ai site directly

Interactive Transcript:
Want to try the interactive transcript? (It's currently a bit RAM-intensive) Yes!

Resources

The process for this is actually pretty simple.

BUT!!!

You’ll first need to get the website’s content into your gsheet as markdown.

(Which is slightly less simple)

To do this, you can use the “Turning A Webpage Into Markdown (For AI Analysis) → via Apify” technical guide, then come back here after.

SOP

  • Get all of your markdown content into a google sheet
  • Use this formula: =DETECTLANGUAGE(E2) — (assuming E2 holds your markdown)
  • Once it renders out (might require a page refresh), you can copy and paste the column’s values “as values” into a new column (”edit” menu → “paste special” → “values only”)
  • Now you can sort by your new column’s values
  • And delete all the rows that aren’t your target language (or whatever you want)
  • Done! EZPZ
Previous Module
Back to Module
Next Module