PHPackages                             piedweb/google-spreadsheet-seo-scraper - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Utility & Helpers](/categories/utility)
4. /
5. piedweb/google-spreadsheet-seo-scraper

AbandonedArchivedLibrary[Utility & Helpers](/categories/utility)

piedweb/google-spreadsheet-seo-scraper
======================================

Open source excel or libreoffice and PHP SEO google position SERP checker to track and follow a few website's keywords positions

0.1.24(3y ago)47.5kMITPHPPHP >=8.1

Since Oct 28Pushed 3y ago1 watchersCompare

[ Source](https://github.com/PiedWeb/google-spreadsheet-seo-scraper)[ Packagist](https://packagist.org/packages/piedweb/google-spreadsheet-seo-scraper)[ Docs](https://dev.piedweb.com)[ RSS](/packages/piedweb-google-spreadsheet-seo-scraper/feed)WikiDiscussions main Synced today

READMEChangelogDependencies (3)Versions (25)Used By (0)

[![Open Source Package](https://raw.githubusercontent.com/PiedWeb/piedweb-devoluix-theme/master/src/img/logo_title.png)](https://dev.piedweb.com)

Google Spreadsheet Seo Scraper
==============================

[](#google-spreadsheet-seo-scraper)

[![Latest Version](https://camo.githubusercontent.com/915a3c827db18da1da606d1fa38b9c926b4c0b8fab39d981142e2f949740c2c8/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f7461672f506965645765622f506965645765622e7376673f7374796c653d666c6174266c6162656c3d72656c65617365)](https://github.com/PiedWeb/PiedWeb/tags)[![Software License](https://camo.githubusercontent.com/f251623e510f5909f16ae3f4e6e548dac11340b9fde1a99be26b015b39272c00/68747470733a2f2f696d672e736869656c64732e696f2f62616467652f6c6963656e73652d4d49542d627269676874677265656e2e7376673f7374796c653d666c6174)](LICENSE)[![GitHub Tests Action Status](https://camo.githubusercontent.com/99edef5bb98e341114d3f938b6eeb8831cd37e46cfa945154e1a17b6c439f056/68747470733a2f2f696d672e736869656c64732e696f2f6769746875622f616374696f6e732f776f726b666c6f772f7374617475732f506965645765622f506965645765622f72756e2d74657374732e796d6c3f6272616e63683d6d61696e)](https://github.com/PiedWeb/PiedWeb/actions)[![Quality Score](https://camo.githubusercontent.com/afefb9c71d9eb75d21eabf82f8606570641e7d80374b13c8d21a9f2745731000/68747470733a2f2f696d672e736869656c64732e696f2f7363727574696e697a65722f672f506965645765622f506965645765622e7376673f7374796c653d666c6174)](https://scrutinizer-ci.com/g/PiedWeb/PiedWeb)[![Code Coverage](https://camo.githubusercontent.com/ad1c5df148038d50b23b6d13436b75553ac9e6d133450cf73859c7bec532334b/68747470733a2f2f636f6465636f762e696f2f67682f506965645765622f506965645765622f6272616e63682f6d61696e2f67726170682f62616467652e737667)](https://codecov.io/gh/PiedWeb/PiedWeb/branch/main)[![Type Coverage](https://camo.githubusercontent.com/92a9cae37a1391395968437e74aca983df381125f0db54069dbe9d52f4a5d483/68747470733a2f2f73686570686572642e6465762f6769746875622f506965645765622f506965645765622f636f7665726167652e737667)](https://shepherd.dev/github/PiedWeb/PiedWeb)[![Total Downloads](https://camo.githubusercontent.com/d55eda4bb703645ff01793310ae3b737be5416e0943070d73b761d9ccec4b3a5/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f64742f706965647765622f676f6f676c652d73707265616473686565742d73656f2d736372617065722e7376673f7374796c653d666c6174)](https://packagist.org/packages/piedweb/google-spreadsheet-seo-scraper)

Open source excel/libreoffice and PHP SEO google position SERP checker to track and follow a few website's keywords positions.

Homepage :

Requirements
------------

[](#requirements)

**PHP**, **CURL**, **composer**, **unoconv** and **libreoffice**

Install
-------

[](#install)

Via [Packagist](https://packagist.org/packages/piedweb/google-spreadsheet-seo-scraper)

```
$ # create the folder where you will install the soft
$ mkdir gs3 && cd gs3
$ # install the lib via composer
$ composer require piedweb/google-spreadsheet-seo-scraper
$ # create a link to the executable
$ ln -s vendor/piedweb/google-spreadsheet-seo-scraper/scrap.php console && chmod +x console
```

Usage
-----

[](#usage)

```
$ gs3/console
    --ods path/to/myfile.ods
    --domain host.tld
```

### Facultative args

[](#facultative-args)

```
--proxy ip:port:username:pass (without proxy, you can check between 20 and 50 kw)
--cache /my/cache/folder/for/google/result (plain html)
--num-100 per default, the script check only the first result page.
          Using it permit to check the 100st results if the domain was not found
--sleep 60 (default, time to wait in seconds between to request on google)
--quiet
```

### Examples

[](#examples)

```
$ php scrap.php --ods "./kw.ods" --domain piedweb.com

```

```
$ php scrap.php --ods "./kw.ods" --domain piedweb.com,piedweb.fr

```

```
$ php scrap.php --ods "./kw.ods" --domain "you can set it directly in your ods file for each row"

```

About `kw.ods`
--------------

[](#about-kwods)

> Seule les colonnes jusqu'à J sont importantes. Il est possible d'archiver autant de données que voulues dans les colonnes suivantes à condition de ne pas avoir deux colonnes portant le même nom. le doc peut être agrémenter de plusieurs feuilles à condition que la feuille par défaut reste la première.

> [Robin Delattre](https://www.robin-d.fr/)

Debugging `tendance` formula

```
=IF(J6="";"";                   // Si prev_pos est vide alors rien
    IF (J6="FAILED";"";            // Si prev_pos a échoué, alors rien
        IF(H6="FAILED";"";              // Si pos a échoué alors rien
             IF(H6="";"";                   // Si pos est vide alors rien
                IF(H6=-1;"x";                   // si kw n'est pas position, alors x
                    IF (H6=J6;"=";
                        IF(H6