Hey can I extract the data which I received by mail to a google or excel sheets
There’s no built-in “export to spreadsheet”, but you have a few routes depending on what you’re after.
If you just need the messages out of Mailspring, right-click a folder in the sidebar and choose Export folder as .mbox file… or Export folder as .eml files… (1.20+/1.23+), or select conversations and Save as .eml…. Those are standard formats that plenty of scripts and tools can turn into rows.
If you want to query the data directly, Mailspring’s cache is a plain SQLite file, edgehill.db, in the data folder (~/.config/Mailspring on Linux, ~/Library/Application Support/Mailspring on macOS, %AppData%\Mailspring on Windows — see Can I change where Mailspring stores my mail? — Mailspring Documentation). Quit Mailspring, copy the file, and open the copy in any SQLite tool: the Message table has subject/sender/date for every message, and MessageBody has the HTML body for messages Mailspring has downloaded (roughly the last few months plus anything you’ve opened). From there a CSV export into Sheets or Excel is a couple of clicks.
And if you’re automating this, 1.23 added an opt-in local MCP server (Preferences > MCP Server) that exposes search_mail / get_message tools, so a script or AI agent can pull the messages it needs without touching the database.