Boardfeed

Import guide

Import Google Search Console data into monday.com

Search Console is where you find out which searches bring people to a site, and it is a report rather than a list: a date, a query or a page, and four numbers beside them. Copying it into monday.com has always meant exporting a CSV from the web interface and pasting it, which is a snapshot with no history and no way to compare it with last month.

Boardfeed reads one site’s search analytics on a schedule and writes one item per **day per query** (or per **day per page**) into a monday.com board. The credential is not a key you paste: you connect the Google account that owns the property, once, and Boardfeed stores the account — not the token — against the source.

Last checked : the six columns one row holds, the window and the two breakdowns, read off the connector — whose endpoints are marked unverified in docs/connectors.md § Search Console until the Google app exists, and this page repeats that position rather than claiming more

Doing it by hand, every time

  1. Open Search Console, set the date range, and export the queries or pages as a CSV.
  2. Upload that file to the board and map the columns again, every time.
  3. Do it again next week, and keep the old export somewhere if you want to compare.
  4. Notice too late that the numbers you compared were two different date ranges.

The scheduled route

  1. Connect the Google account that owns the property. Boardfeed opens Google’s own consent screen in a small window, asks for **read-only** Search Console access, and stores the connection encrypted (AES-256-GCM). No token ever reaches the board, the browser or a log, and you can revoke the account from the Support tab at any time.
  2. Choose the property from the list Boardfeed reads back — Search Console answers with the sites the account can see, each with your permission level on it — and choose how to break the report down: by **query**, or by **page**. One import reads one of the two.
  3. Choose how many days back to read. Left empty it is the last 28 days, which is the window the Search Console interface itself shows, and the run counts back from the day it runs. A scheduled import therefore re-reads the same window every time, which is why the next step matters.
  4. Key the import on the date and the query (or page) and run it in **update matching items** mode: a fresh run then updates the row it already wrote instead of adding a second copy of the same day. In create mode, running the same window twice is two sets of items — that is the mode, not a bug.
  5. Every run reads the window from today’s date backwards, which means the numbers for the last day or two can still change afterwards: Search Console settles its data for a few days, so a row imported yesterday may be updated today. Boardfeed is not the source of that revision — Google is — and the update mode is what keeps the board in step with it.

Field mapping notes for Google Search Console

This is the part that decides whether an import works on the first try. Everything below is handled in the mapping step, before the first run.

  • One row is one line of the report, and it has exactly six fields: `date` (the day the numbers are for), `query` — or `page`, when you chose that breakdown — `clicks`, `impressions`, `ctr` and `position`. Nothing is renamed and nothing is computed.
  • `ctr` arrives as the fraction Google sends, `0.035` for 3.5 %, not as a percentage. Map it to a Numbers column and read it as a decimal, or ask Google’s own wording in the reports you compare it with.
  • `position` is the average position of the site in the results for that day and that query — 8.4 means it averaged between the eighth and ninth result. It is a number, not a rank, so a lower value is better and a chart of it wants its axis reversed.
  • `date` is `YYYY-MM-DD` and maps to a Date column as it comes. `query` is the text someone typed and `page` is the URL that was shown, so a board that breaks down by page reads better with that column set to Link or Text rather than to a status.
  • The four numbers are Google’s, one day at a time. Impressions can be zero on a day a query was not shown at all, and Search Console omits rows it has no data for rather than sending zeros — so a day missing from the board is a day with nothing to report, not a failed read.

Google Search Console import questions

Do I need to create a Google Cloud project or an API key?

No. You connect a Google account, from the source dialog, and Google asks that account whether Boardfeed may read Search Console for it — read-only, and nothing else. There is no key to create, paste or rotate, and nothing to paste into a settings page.

Which Search Console properties can I import?

The ones the connected account can see. Boardfeed asks Search Console for the list and shows it in the source dialog with your permission level beside each site — the property is chosen from that list rather than typed. Both kinds of property are supported: a URL-prefix property (`https://example.com/`) and a domain property (`sc-domain:example.com`).

How far back can a run read?

Google keeps roughly sixteen months of search data, and an import of a longer window reads that window rather than refusing. Four weeks (28 days) is the default because it is what the Search Console interface shows and what fits a board that is read rather than archived. Note that a scheduled import reads the same window again on every run, so a report that reaches back months is one to run weekly rather than daily.

Does Boardfeed write anything back to Search Console?

No. The permission it asks for is read-only, and the connector only reads: one request per page of results, and no writes of any kind. The connected account can be revoked from the Support tab, which tells Google to forget the grant and removes the stored connection.

What happens if the connected account is revoked or expires?

The next run fails with a sentence naming the account, and it is recorded in the run history like any other source error — nothing is written to the board. Reconnect the account from the source dialog and run it again. Disconnecting an account in the Support tab also names the imports that read it before it revokes anything, so you can see what a disconnection would break.

Why do the numbers for yesterday change after I have imported them?

Because Search Console revises them. Google settles search data over the days after it is first reported, so the impressions of a day two days ago can still move. Boardfeed reads whatever Search Console answers at the moment the run starts; an import keyed on the date and the query, in update mode, is what keeps the board matching the report rather than the report as it was last Tuesday.

Other sources