Thank you, PaulS. Here is what I did per your suggestions:
Added a delimiter to each string to see if either had extra spaces, CR, or LF's....
String str= client->getResponseBody();
Serial.print("Output from Google Sheet: [");
Serial.print(str);
Serial.print("]");
and it looks like there was a CR printing because this came out of the serial monitor:
Output from Google Sheet: [Beer Purchased
]Output from 'purchase' string: [Beer Purchased]
--------------------Error:Beer Purchase string is not a match
So I added str.trim(); just before printing it:
String str= client->getResponseBody();
str.trim();
Serial.print("Output from Google Sheet: [");
Serial.print(str);
Serial.print("]");
But they still are not equal somehow...this is how they are printing to the serial monitor:
Output from Google Sheet: [Beer Purchased]Output from 'purchase' string: [Beer Purchased]--------------------Error:Beer Purchase string is not a match