Build temp. MD pages from GSheets JSON for Hugo Site

zivbk1 · January 1, 2019, 1:17am

Demonstration of how I generated temporary .md files from two merged sets of JSON data (Google Sheets API). These .md files are only generated and used during compilation and are not saved into the repository.

github.com

IslandViewPTA/islandview-pta-site/blob/master/src/scripts/gspread2md.py

# Takes data from Google Spreadsheets and outputs information from them as a Markdown file with YAML front matter named after column headings.
# Inspired by: https://github.com/EvanLovely/csv_to_jekyll

# Import the python libraries.
import gspread
from oauth2client.service_account import ServiceAccountCredentials
from pathlib import Path
import os
import json

# Delete old page files. Leave the _index.md file there.
[ os.remove("site/content/colorrun/" + f) for f in os.listdir("site/content/colorrun/") if not f.startswith("_") and f.endswith(".md") ]

# Get JSON_DATA from the build environment.
jsondict = json.loads(os.environ['JSON_DATA'])

# Use creds to create a client to interact with the Google Drive API
scope = ['https://spreadsheets.google.com/feeds','https://www.googleapis.com/auth/drive']
creds = ServiceAccountCredentials.from_json_keyfile_dict(jsondict, scope)
client = gspread.authorize(creds)

This file has been truncated. show original

This is a fairly simple script, but you can see that I needed to do some filtering of the data source and mapping the 2 source JSON data sets to front matter parameters per page.

Topic		Replies	Views
Front-end user submitted content via forms	4	946	January 6, 2021
Automatically generate pages from JSON data file support	9	10170	July 19, 2019
How to use Google Sheets to generate MD files? (without using netlify) support	4	294	December 9, 2023
[TIP]: Generate Pages from Remote - Is it possible to generate a JSON file, dynamically, at build time? - support	15	1503	December 19, 2021
Generate page from json rather than md support	2	2723	May 12, 2016

Build temp. MD pages from GSheets JSON for Hugo Site

Related Topics