рд╕рднреА рдЯреЗрдореНрдкрд▓реЗрдЯ
SEOBeginner

Google Ads Metrics to Sheets

RobomotionтАв3 рдорд╛рд╣ рдкрд╣рд▓реЗ рдЕрдкрдбреЗрдЯ рдХрд┐рдпрд╛ рдЧрдпрд╛
Google Ads Metrics to Sheets

рдУрд╡рд░рд╡реНрдпреВ

Reads a column of keywords from a Google Sheet and fills in the Google Ads planner numbers for all of them in one call: monthly search volume, competition and cost per click.

Google Ads Metrics to Sheets

Reads a column of keywords from a Google Sheet and fills in the Google Ads planner numbers for all of them in one call: monthly search volume, competition and cost per click.

How it works

  1. Every 15 Minutes тАФ an Inject trigger repeating every 900 seconds.
  2. Get Keywords / Collect Keywords тАФ the Keyword column becomes one array of up to 1000 entries; the market comes from the first row that names a Location or Language.
  3. Get Ads Metrics тАФ DataForSEO.KeywordData.SearchVolume, a first-class node in the package.
  4. Merge Metrics Into Rows тАФ indexes the response by keyword and rewrites the table in place so every row keeps its position.
  5. Write Metrics Back тАФ one SetRange from A1.

One call covers up to 1000 keywords, so a full keyword list costs the same as a single lookup.

Setup

  • DataForSEO credential тАФ API login and password from https://app.dataforseo.com/api-access.
  • Google credential тАФ Service Account or OAuth2 with access to the spreadsheet.
  • A sheet with a Keyword column; Location, Language, Search Volume, Competition and CPC are filled in by the flow.

Ported from

SEO рдХреЗ рдФрд░ рдЯреЗрдореНрдкрд▓реЗрдЯ

рд╕рднреА 53 рджреЗрдЦреЗрдВ тЖТ