Click the link below to copy the template:
A tab containing a prompt asking you to copy the spreadsheet to your Google account appears. Click Make a copy.
You will get a copy of the template with the following sheet:
Search query is for what you want to look for in your Gmail. Type it in cell B2. Also indicate how many email threads you want to list. Input it to cell B3.
You can also load email attachments to the sheet. To do so, simply tick the checkbox on the right of the Attachment heading.
What this option does is to save each attachment to your Google Drive and then load a link to each attachment to the sheet. Since email attachments can still contain viruses, make sure to enable this option only if you are confident that all the attachments are safe to open.
Once you set the Search query and the Number of emails to load, click Search Emails. On the first run, you will be asked to authorize the script attached to the spreadsheet. Click OK.
A new window will load. You will be asked first to choose the Google account that will run the script. Select the account you are using in the list. Most of the time, only the active account will be listed.
You will next get the message that Google hasn’t verified the script. Click the small link labeled Advanced. Another link will appear below it. Click Go to gmailtosheets(unsafe).
Next, a list of permissions needed by the script will be listed.
Click Allow. The window will close.
The spreadsheet now works. Click Search Emails again, and the results will load!
You will get the following information loaded to your sheet:’
Did you like it? Copy the template below and use it!
Save hours on repetitive and tedious work. Lido is a new spreadsheet that connects your spreadsheets, forms, PDFs, and email inbox.