This is probably The Stranger Within, a 1974 American made-for-television science fiction horror film that premiered as the ABC Movie of the Week on October 1, 1974 and starring Barbara Eden and George Grizzard.
Plot Summary from Wikipedia
Ann Collins (Eden), a painter, and her husband, David Collins (Grizzard), are expecting a baby. What confuses the couple is that David has had a vasectomy, and Ann is not supposed to be pregnant. Even though David suspects that Ann has been unfaithful to him, he stays with her. Because Ann had pregnancy troubles in the past that put her health at risk, David wants Ann to get an abortion, but every time the two try to go to get the procedure done, Ann experiences extreme labor pains and is unable to go through with the procedure.
Throughout the course of her pregnancy, Ann has strange cravings for black coffee, raw meat and massive amounts of salt. She also exhibits personality and physical changes, including wanting to read books constantly, enduring freezing temperatures, developing acutely sensitive hearing, taking long and strenuous walks in the mountains, an inability to listen to other people, and healing her injuries within minutes.
David wants Bob (David Doyle), a hypnotist, to see if he can obtain any information about why Ann is acting so strangely. Ann does not say a word, even when she is hypnotized. One day when Ann comes home from one of her walks in the mountains, she finds David, Bob, and Ann's friend Phyllis (Joyce Van Patten) waiting for her. She quickly drinks boiling hot coffee to catch her breath, and David notices that the coffee makes her drunk. Bob tries hypnotizing Ann again, and an extraterrestrial being starts speaking through her. The being says that his father banished him to this warm planet (Earth) and that he wants to go back to his home where it is "cool". He says that Ann was impregnated while she was painting in the mountains. After the alien stops talking through Ann, she finally falls asleep.
During the night, Ann sneaks out to an abandoned house in the woods, where she gives birth. She walks into the woods, where many other women are also walking with their alien babies. David looks at one of Ann's paintings, depicting the alien being's home planet. The painting starts to smoke. David looks out the window and screams Ann's name, as he watches a spacecraft take Ann to the alien's home planet.
It fits your time period and features an alien who accidentally gets drunk on coffee.