rangit3 / taskstomap

Google Sheets/Excel to Google maps - make your tasks managable in one map

Tasks to Google Maps

Make your tasks managable in one map

Features

• Input: a csv file that have addresses in a column named Address
• Output: a csv that have 3 more columns:

-- addresses_found: which address was generated by the api
-- lat - the latitude of the address
-- long - the longitude of the address

Advanced Features

• Get the excel directly from google sheets.
• Tasks can be added to the google sheet automatically via Google Forms or other application.
• Use Google Colab for full pipeline without any installations
• Use Google Maps API to update the map

Installation

Python 3.6+
pip install -q -r requirements.txt

Usage guides

1. Fill google sheets/ csv file with taksk

###Must have column named "Address"

3. Rename the csv "reports.csv"

4. Run the script. output is "reports_updated.csv"

5. Create a new google maps

6. Click on import (ייבוא)

7. Select the location columns

8. The output is

Google Colab Usage guides

Create a notebook and add the following commands (or download the notebook in the repo).

Fill the parameter URL, and index if the column name of the address is not "Address".

####Params#####
#google sheet with the tasks:
URL = ''

####Optional Params#####
# the index (starts at 0) where the address column is
# -1 means to look for column which the first cell is 'Address'
ADDRESS_INDEX = -1

# the index (starts at 0) of the worksheet to download
WORKSHEET_INDEX = 0

# Fixing the csv: There are additional parameters to fix the csv.
# Fill Cells: An option to fill the csv with default values per column. For example: !python main.py --index {ADDRESS_INDEX} --fill_pairs Status=חדש,Name=אנונימי
# Ignore Lines: An option to ignore lines with specific values inside a cell. For example: !python main.py --index {ADDRESS_INDEX} --ignore_pairs Status=נמסר

####Import The Code#####
%cd /content
#!pip install --upgrade -q gspread
%rm -r TasksToMap &> /dev/null
!git clone https://github.com/rangit3/TasksToMap.git

####Run The Code#####
from google.colab import auth
import csv
auth.authenticate_user()

import gspread
from google.auth import default
creds, _ = default()

gc = gspread.authorize(creds)
sheet = gc.open_by_url(URL)
worksheet = sheet.get_worksheet(WORKSHEET_INDEX)
data = worksheet.get_all_values()

with open('/content/TasksToMap/reports.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile)
    writer.writerows(data)

#upload the input csv into the created folder, and name it as reports.csv
%cd /content/TasksToMap
!pip install -q -r requirements.txt
print("\nCode is running\n")
!python main.py --index {ADDRESS_INDEX}

####Save the Results to Google Drive#####
from google.colab import drive
drive.mount("/content/drive", force_remount=True)
!cp reports_updated.csv /content/drive/MyDrive

print("\nDone. Search for reports_updated.csv in your drive!")

Licence

The Unlicense

A license with no conditions whatsoever, except terrorists.

taskstomap's Issues

Create an application that can add tasks and integrate google maps in the application

The list should be local and synced to drive. No other 3rd parties.

Add an option to get the excel directly from google sheets link

One click usage - Use Google Maps API to update the map directly from the script

Add the option to run the code in a mobile phone - javascript?

Edit the spreadsheet via Parameters

Allow to ignore rows, fill row, etc.

Make an update script - if the map updates, it updates the sheet. Also in the other way

Improve the Readme file

Output as kml to more advanced options in creating the map