<aside> 📌 Guide built by Lucas Perret from lemlist.com

Follow me for more content about sales automation 🔥

And check lemlist if you need a cold email software with flawless deliverability 🚀

</aside>

Set-up

• [ ] Create a new Google Sheets file

• [ ] Go to Extensions → Apps Script

• [ ] Remove all the code and copy-paste the following instead

• expand to see the code to copy paste

• [ ] Get your SimilarWeb API Key

  • [ ] Go https://account.similarweb.com/journey/registration and register
  • [ ] go to the following page

  SimilarWeb Identity

  • [ ] Generate a key and copy it

  

  • [ ] Paste it into your Google Apps Script project
  • [ ] If everything is ok, it should look like this:

  

• [ ] Save your project and go back to your sheet

• [ ] Use =getTraffic({domain}) like a classic Google Sheets Formula

Found this guide useful?

Follow me on Linkedin for more ↓

https://www.linkedin.com/in/lucas-perret/