Looker Studio Automation Expert – Build Nookal ? Google Data Dashboards

Please login or register as jobseeker to apply for this job.

: TYPE OF WORK

Gig

: SALARY

30000

: HOURS PER WEEK

TBD

: DATE UPDATED

Nov 18, 2025

JOB OVERVIEW

GIG SUMMARY:

We’re looking for a Looker Studio, API, and automation specialist who can create automated dashboards by pulling data from Nookal (our practice management system) into Looker Studio using Google Sheets, BigQuery, Apps Script, or a custom API workflow.

If you're a data engineer-type freelancer who loves automation and analytics — this gig is for you.

WHAT WE NEED BUILT:
1. Automated Data Pipeline (Nookal ? Looker Studio)

You must be able to:
- Connect to the Nookal API
- Fetch appointments, revenue, clinician activity, services, invoices, and attendance
- Push the data automatically into Google Sheets or BigQuery
- Keep the data refreshed daily (or more often)

2. Looker Studio Dashboards

We need clean, interactive dashboards for:
• Revenue
• Utilisation & attendance
• EP/Physio/Dietetics KPIs
• SPEC / Retention / UCVA metrics
• Clinician performance summaries
• Pre-Employment Medical analytics
• NPS dashboards
• Finance (Nookal + Xero combined)

3. Automation & Error Checking

• Daily updates
• Alerts if data fails
• Clean formatting
• Smart data transformations
• Easy-to-use structure for future expansion

SKILLS REQUIRED:

- Looker Studio (advanced)
- API connections + documentation reading
- Google Apps Script or Python
- ---------- or Zapier (automation tools)
- Google Sheets (data cleaning & formulas)
- BigQuery experience is a bonus
- Data modelling + dashboard design
- Ability to propose better solutions, not just follow a list

WHAT MAKES THIS PROJECT UNIQUE:

- We don’t want manual exports — we want automation
- You’ll work directly with the CEO
- You’ll be building dashboards that influence clinical decisions
- This is not a basic VA gig — this is a data engineering + analytics project
- Ongoing work available for the right expert

DELIVERABLES:

Automated data pipeline (Nookal ? Sheets/BigQuery ? Looker)
At least 4 main dashboards completed
Documentation of your workflow
Training video for our team on how to maintain it

BUDGET RANGE:

Depending on your expertise:
?20,000–?30,000 PHP

This gig is for an expert, not a beginner.

TO APPLY, SEND:

• 2–3 examples of Looker dashboards you built
• Any API or automation projects you’ve done
• How YOU would connect Nookal ? Looker Studio
• Your quote + timeline
• Your availability for the next 4 weeks

SKILL REQUIREMENT

Google Data Studio Admin Data Processing API Development

SHARE THIS POST

Job Post	Reporter	Rank	Reason	Date

BENCHMARKS

Loading Time: Base Classes	0.0008
Controller Execution Time ( Jobseekers / Job )	0.0233
Total Execution Time	0.0246

GET DATA

No GET data exists

MEMORY USAGE

1,507,256 bytes

POST DATA

No POST data exists

URI STRING

jobseekers/job/Looker-Studio-Automation-Expert-Build-Nookal-Google-Data-Dashboards-1516268

CLASS/METHOD

jobseekers/job

DATABASE: onlinejobs (Jobseekers:$db) QUERIES: 13 (0.0176 seconds) (Hide)

0.0003	`SELECT * FROM exrates WHERE rate_name = 'USD-PHP'`
0.0010	SELECT * FROM `employer_jobs` WHERE `job_id` = 1516268 LIMIT 1
0.0014	SELECT * FROM `employers` WHERE `employer_id` = 115987 LIMIT 1
0.0008	SELECT COUNT(*) AS `numrows` FROM `t_thread` `t` LEFT JOIN `t_thread_misc` `misc` ON `t`.`id` = `misc`.`thread_id` WHERE `t`.`job_id` = 1516268 AND `misc`.`id` IS NULL
0.0004	SELECT e.business_name, e.logo, e.website, e.rebill_date, e.date_added member_date, hits, DATEDIFF('2026-04-17',ej.date_added) duration_days, DATEDIFF('2026-04-17',e.rebill_date) duration_rebill, ej.*, e.deactivate FROM employers e, employer_jobs ej WHERE e.employer_id = ej.employer_id AND ((e.user_level >= '500' AND ej.date_added <= e.rebill_date) OR e.employer_id = '' OR (ej.date_approved <> '2000-01-01' and DATEDIFF('2026-04-17',ej.date_added) <= 14 )) AND e.deactivate != 1 AND ej.deleted = 0 AND job_id = '1516268'
0.0007	SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 1516268
0.0013	UPDATE employer_jobs SET hit_counts = '*Nov-18-2025=127Nov-19-2025=45Nov-20-2025=14Nov-21-2025=5Nov-22-2025=5Nov-23-2025=8Nov-24-2025=6Nov-25-2025=6Nov-26-2025=4Nov-27-2025=1Nov-28-2025=9Nov-29-2025=3Nov-30-2025=3Dec-01-2025=7Dec-02-2025=2Dec-03-2025=5Dec-04-2025=3Dec-05-2025=4Dec-06-2025=5Dec-07-2025=4Dec-08-2025=5Dec-09-2025=1Dec-10-2025=2Dec-11-2025=5Dec-12-2025=5Dec-13-2025=4Dec-14-2025=2Dec-15-2025=4Dec-16-2025=4Dec-17-2025=6Dec-18-2025=2Dec-19-2025=4Dec-20-2025=2Dec-21-2025=1Dec-22-2025=1Dec-23-2025=4Dec-24-2025=1Dec-25-2025=4Dec-27-2025=3Dec-28-2025=2Dec-29-2025=1Dec-30-2025=4Jan-01-2026=7Jan-02-2026=3Jan-03-2026=4Jan-05-2026=4Jan-06-2026=4Jan-07-2026=4Jan-08-2026=3Jan-09-2026=5Jan-10-2026=3Jan-11-2026=1Jan-12-2026=5Jan-14-2026=2Jan-15-2026=2Jan-16-2026=1Jan-17-2026=3Jan-18-2026=5Jan-19-2026=4Jan-20-2026=1Jan-21-2026=3Jan-23-2026=4Jan-24-2026=2Jan-27-2026=2Jan-28-2026=2Jan-29-2026=1Jan-30-2026=2Jan-31-2026=1Feb-04-2026=2Feb-05-2026=2Feb-08-2026=2Feb-09-2026=1Feb-10-2026=1Feb-12-2026=1Feb-13-2026=2Feb-14-2026=1Feb-17-2026=1Feb-19-2026=1Feb-23-2026=1Feb-24-2026=1Feb-28-2026=1Mar-03-2026=1Mar-07-2026=1Mar-10-2026=1Mar-17-2026=1Mar-18-2026=1Mar-20-2026=1Mar-23-2026=1Mar-24-2026=2Mar-26-2026=2Mar-27-2026=2Mar-28-2026=1Mar-30-2026=1Apr-03-2026=1Apr-06-2026=1Apr-09-2026=1Apr-10-2026=1Apr-14-2026=1**Apr-17-2026=1' WHERE job_id= '1516268'
0.0006	`UPDATE employer_jobs SET monthly_hits = '*Nov-2025=236Dec-2025=97Jan-2026=78Feb-2026=17Mar-2026=15*Apr-2026=6' WHERE job_id= '1516268'`
0.0008	`SELECT date_sent FROM jobseeker_sent_emails WHERE jobseeker_id = '' AND job_id = '1516268' AND status LIKE 'sent%' ORDER BY id DESC`
0.0003	SELECT * FROM `employer_jobs_skills` `ejs` LEFT JOIN `skills_categories` `sc` ON `ejs`.`skill_id` = `sc`.`id` WHERE `job_id` = 1516268
0.0077	SELECT COUNT(*) AS `numrows` FROM `employer_jobs` WHERE `employer_id` = '115987' AND `date_added` >= '2022-06-08'
0.0003	`select * from teasers`
0.0018	`SELECT * FROM skill_categories WHERE skill_cat_id=''`

HTTP HEADERS (Show)

SESSION DATA (Show)

__ci_last_regenerate	1776421367
last_page	https://v1.stage.onlinejobs.ph/jobseekers/job/Looker-Studio-Automation-Expert-Build-Nookal-Google-Data-Dashboards-1516268
csrf-token	dc845b0142619335d95618c5b8ad1d5d

CONFIG VARIABLES (Show)

base_url	https://v1.stage.onlinejobs.ph
log_threshold	2
enable_profiler
index_page
uri_protocol	PATH_INFO
url_suffix
language	english
charset	UTF-8
enable_hooks	1
subclass_prefix	MY_
composer_autoload	vendor/autoload.php
permitted_uri_chars	a-z 0-9~%.:_\=\-\+\@?\&
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
allow_get_array	1
log_path
log_file_extension
log_file_permissions	420
log_date_format	Y-m-d H:i:s
error_views_path
cache_path
cache_query_string
encryption_key	OdBUArjiWg9I7u7bvAwQ7Fu35VB1kzga
sess_driver	files
sess_cookie_name	ci_session
sess_expiration	2678400
sess_save_path
sess_match_ip
sess_time_to_update	300
sess_regenerate_destroy
cookie_prefix
cookie_domain
cookie_path	/
cookie_secure
cookie_httponly
standardize_newlines
global_xss_filtering	1
csrf_protection
csrf_token_name	csrf_test_name
csrf_cookie_name	csrf_cookie_name
csrf_expire	7200
csrf_regenerate	1
csrf_exclude_uris	Array ( )
compress_output
time_reference	local
rewrite_short_tags
proxy_ips
ojadmin	JpjZkQN5A8l@^L
salt	+UFjSAT49tPZLtmU2CIG2FYN7pRhgsWyLHgSyQa6k3I=
queue_enabled
twilio	Array ( [sid] => AC00c0594045c6eef9407e8fff01f3d467 [token] => f0bfc0b73444a077894a43f5f75e6d41 [length] => 6 [from] => +639221200200 [code_expiry_seconds] => 14400 )
maintenance	Array ( [admin] => Array ( [verification] => ) [announcement_bar] => Array ( [show_slow_issue_message] => ) )
trustpilot	Array ( [to_email] => onlinejobs.ph+3d844ebf71@invite.trustpilot.com )
services	Array ( [google_tag_manager] => Array ( [id] => GTM-T5CQMS6P ) [chatgpt] => Array ( [secret] => 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 ) [claude] => Array ( [secret] => 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 ) )
v2_url	https://v2.stage.app.onlinejobs.ph
replacemyself_secret_key	Kk1WpgTMkc4wBQOqC5rqCssdLhACKrsJeTtO1ywUkT4=
app	Array ( [app] => Array ( [command] => Array ( [map] => Array ( [OnlineJobs\Mailer\Command\SendEmailCommand] => OnlineJobs\Mailer\Handler\SendEmailHandler [OnlineJobs\Mail\Command\SendEmailCommand] => OnlineJobs\Mail\Handler\SendEmailHandler [OnlineJobs\Mail\Command\QueueEmailPendingCommand] => OnlineJobs\Mail\Handler\QueueEmailPendingHandler [OnlineJobs\Mail\Command\QueueJobEmailPendingCommand] => OnlineJobs\Mail\Handler\QueueJobEmailPendingHandler [OnlineJobs\Mail\Command\QueueUnapprovedEmailCommand] => OnlineJobs\Mail\Handler\QueueUnapprovedEmailHandler [OnlineJobs\Mail\Command\ProcessEmailQueueCommand] => OnlineJobs\Mail\Handler\ProcessEmailQueueHandler [OnlineJobs\Mail\Command\PutJobseekerEmailOnHoldCommand] => OnlineJobs\Mail\Handler\PutJobseekerEmailOnHoldHandler [OnlineJobs\Purchase\Command\RealEstateVaCourseCommand] => OnlineJobs\Purchase\Handler\RealEstateVaCourseHandler [OnlineJobs\Test\Command\HelloCommand] => OnlineJobs\Test\Handler\HelloHandler ) [middleware] => Array ( ) ) [providers] => Array ( [0] => OnlineJobs\Bus\BusServiceProvider [1] => OnlineJobs\Database\DbServiceProvider [2] => OnlineJobs\Mailer\MailerServiceProvider [3] => OnlineJobs\Support\SupportServiceProvider [4] => OnlineJobs\Employer\ServiceProvider [5] => OnlineJobs\Jobseeker\ServiceProvider [6] => OnlineJobs\Mail\ServiceProvider [7] => OnlineJobs\Postal\ServiceProvider [8] => OnlineJobs\Queue\ServiceProvider [9] => OnlineJobs\Courier\ServiceProvider [10] => OnlineJobs\Job\ServiceProvider [11] => OnlineJobs\Purchase\ServiceProvider ) ) )
meta	Array ( [facebook] => Array ( [input] => 1 [connect] => 2 [timezone] => 3 [url] => 30 [id] => 31 [photo] => 32 [name] => 33 [email] => 34 [review] => 35 ) [trust] => Array ( [government_id] => 4 [utility_bill] => 5 [selfie_photo] => 6 [profile_picture] => 7 [phone_number] => 8 [facebook] => 9 ) [verify] => Array ( [profile_picture] => 10 [government_id] => 11 [selfie_photo] => 12 [utility_bill] => 13 [address] => 14 [name] => 15 [reviewed] => 16 [government_group] => 28 [address_group] => 29 [mobile] => 38 ) [address] => Array ( [complete] => 17 [room_unit_no] => 20 [house_no] => 21 [street] => 22 [subdivision] => 23 [barangay] => 24 [city] => 25 [province] => 26 [postcode] => 27 ) [reviewed] => Array ( [similar_names] => 1 ) [name] => 18 [phone] => 19 [sms_verification_code] => 36 [resend_verification_code] => 37 [address_read] => 39 [first_name] => 100 [middle_name] => 101 [last_name] => 102 [edit] => Array ( [government_id_group] => 40 [address_group] => 41 [mobile_group] => 42 ) [salary_re_entry] => 103 [id_proof_recalibrate] => 104 [email] => 44 [mobile_verification_type] => 45 )
honeypot	Array ( [name_field] => my_name [enabled] => 1 )

HTTP_ACCEPT	/
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_CONNECTION	Upgrade
SERVER_PORT	80
SERVER_NAME	v1.stage.onlinejobs.ph
REMOTE_ADDR	127.0.0.1
SERVER_SOFTWARE	Apache/2.4.58 (Ubuntu)
HTTP_ACCEPT_LANGUAGE
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_X_FORWARDED_FOR	216.73.216.214
HTTP_DNT

Looker Studio Automation Expert – Build Nookal ? Google Data Dashboards

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

SALARY

HOURS PER WEEK

DATE UPDATED

Why is this blurred?