Script not working - some suggested fixes

[tangerald]

Ben, thanks for this wonderful script. It's been a while since you last published it, but it solved my use case. I wanted to let you know about 3 bugs and how I managed to resolve it. This is my first coding project ever, please forgive me if it was user-error!

p.s. do you know if this script will update historical PC net worth, and Invested Portfolio cells? When I run it, it only gives me details for the current month.

Cheers!

Issue #1:

  File "/Users/gerald/PCAP/main.py", line 248, in <module>
    main()
  File "/Users/gerald/PCAP/main.py", line 174, in main
    result = sheet.values().get(spreadsheetId=SPREADSHEET_ID,
  File "/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages/googleapiclient/discovery.py", line 1040, in method
    raise TypeError('Missing required parameter "%s"' % name)
TypeError: Missing required parameter "spreadsheetId"
gerald@Geralds-MacBook-Pro PCAP % python3 main.py
  File "/Users/gerald/PCAP/main.py", line 174
    result = sheet.values().get(spreadsheetId=1fslSPDuwLYr0M5H7gexxxxx-Jxxxxxx,
                                              ^
SyntaxError: invalid decimal literal

I resolved it by replacing SPREADSHEET_ID = os.getenv('SPREADSHEET_ID')
with SPREADSHEET_ID = 'SPREADSHEET_ID'

Issue #2

The second issue was personalcapital.py's authentication error. I fixed it by using UnusualPi's updated personalcapital.py file. Details here.

Issue #3

The last issue was due to a typo in personalcapital's main.py file, outlined here.